Hi! Thanks for this video. I have a question... I created a table that shows Sum(Sales) as measure, and countries as dimension in rows. The columns are the last 7 days dates. I need to create a conditional format (cell or text color) per each row (gradient min to max), comparing the results for the 7 days in each country. I can't compare all countries results at once, because each one is totally different. How can I do this? Thanks!
How can I a) conditionally format the background colour rather than the text colour and b) change the background colour of the ENTIRE ROW ie in this case, the "Sub category"?
I have 2 queries: 1.) Why Last() is starting from 0 ? 2.) How we can automate Top N & Bottom N instead of going & changing in the code manually in case we need to find Top 5, Bottom 5 one day & Top 7, Bottom 9 the other day ?
if this is only the way to do conditional formatting, really disappointed on tableau. this is very basic feature should be in any BI tool but if I got correctly, in tableau you have to create new fields for each formatting needed so it means data pane will be like garbage. If I am wrong or is there any ideal solution please reply and correct me. Thanks.
Create a calculate field of Boolean type (for ex: CF=SUM([Profit]) > 0). Use this field and drag it over color in Marks card. As the newly created calculate field is of type measure, 2 different colors are set for positive and negative values. Thus, we can text color a negative value.
Click on Format->font. We can choose specific measure (M1) from the fields drop down in the "Format Font". Choose Font from Pane section (Default). Later, choose second measure (M2) and follow same steps.
To Get Certification, Click Here: bit.ly/43cTRUQ
Use coupon "RUclips12" to get ‘’FLAT 12%’’ OFF at Checkout.
Excellent video , thanks for sharing
three hurrahs for this man !!
Need detailed ..like if we have separate table for threshold value and as per that data conditional formatting will happen.. pls make video in detail
Nice explanation
Understood and Nicely explained
Hi! Thanks for this video. I have a question... I created a table that shows Sum(Sales) as measure, and countries as dimension in rows. The columns are the last 7 days dates. I need to create a conditional format (cell or text color) per each row (gradient min to max), comparing the results for the 7 days in each country. I can't compare all countries results at once, because each one is totally different. How can I do this? Thanks!
Great 👍
really great video! thank you!!!!
How can I a) conditionally format the background colour rather than the text colour and b) change the background colour of the ENTIRE ROW ie in this case, the "Sub category"?
Believe me or not, but this feature is not possible in Tableau. That's why your corporation shouldn't decide to go for Tableau. Complete shit.
@@KeithFlint350 Thank you!
You make amazing videos man!
thank you.FA.
Thank You! Very helpful
can also be achieved using Rank()
Thank you Sir!!!
how to download global superstore 2017 i couldn't find the link, please suggest
I have 2 queries:
1.) Why Last() is starting from 0 ?
2.) How we can automate Top N & Bottom N instead of going & changing in the code manually in case we need to find Top 5, Bottom 5 one day & Top 7, Bottom 9 the other day ?
Maybe you can use LAST()+1 to start from 1
You can create a parameter and control the TOP N value with it
With the help of parameters with set you can create custom top N and bottom N
if this is only the way to do conditional formatting, really disappointed on tableau. this is very basic feature should be in any BI tool but if I got correctly, in tableau you have to create new fields for each formatting needed so it means data pane will be like garbage. If I am wrong or is there any ideal solution please reply and correct me. Thanks.
May i know how to make different colour for top 5 and bottom 5 respectively ?
Use if statements to break your calculated fields into cases. Then when you do colours you will see the different options.
awesome...
How to show only the top 10?
at the same time don't use exclude, as I need to choose various top 10 sales for each subcategory
How can i conditionally format the text color if the value in that columns are negative?
Create a calculate field of Boolean type (for ex: CF=SUM([Profit]) > 0). Use this field and drag it over color in Marks card. As the newly created calculate field is of type measure, 2 different colors are set for positive and negative values. Thus, we can text color a negative value.
how can I download the dataset?
With LAST it seems to include a ZERO position so your Bottom 5 is actually 6 figures highlighted. How is that corrected?
For calculated field "Last" use the following formula: LAST()+1
I think we can also use First() calculated field in place of Index().
if we use a first in this situation numbering part is in negative
part
Please upload the excel file.
How do I colors code multiple measures
@Tutorials Point (India) Pvt. Ltd. even I have the same question. I want to add two measures and color the cell background. Please help!
Click on Format->font. We can choose specific measure (M1) from the fields drop down in the "Format Font".
Choose Font from Pane section (Default).
Later, choose second measure (M2) and follow same steps.
Bottom 6 are highlighted, not the bottom 5...
Power Bi takes 2 seconds to do all these 7 minutes work
your tutorial is good, but we do not need to see you.. it's very destructing.