Tableau - Conditional Formatting

[@TutorialsPoint_]

To Get Certification, Click Here: bit.ly/43cTRUQ Use coupon "KZbin12" to get ‘’FLAT 12%’’ OFF at Checkout.

[@lanvinsgivenchy5421]

Excellent video , thanks for sharing

[@arifsheikh2163]

Understood and Nicely explained

[@antoniolupen6138]

three hurrahs for this man !!

[@WhyMe432532]

You make amazing videos man!

[@07jfdr6u]

Great 👍

[@EASYTIGER10]

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"?

[@KeithFlint350]

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.

[@arl2194]

@@KeithFlint350 Thank you!

[@muralid6116]

Nice explanation

[@aryansena7290]

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

[@jaioh2787]

really great video! thank you!!!!

[@franknicaragua]

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!

[@TheDistractionStudio]

Thank You! Very helpful

[@sj8648]

Thank you Sir!!!

[@sowyanss8702]

how to download global superstore 2017 i couldn't find the link, please suggest

[@JonathanJournal]

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

[@Sports-yz1fg]

thank you.FA.

[@hakan0045]

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.

[@piyushgaur9501]

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 ?

[@cuat98]

Maybe you can use LAST()+1 to start from 1

[@cuat98]

You can create a parameter and control the TOP N value with it

[@yashika0511]

With the help of parameters with set you can create custom top N and bottom N

[@prasadvaram]

can also be achieved using Rank()

[@ferideymkli]

how can I download the dataset?

[@HenryHeung0817]

May i know how to make different colour for top 5 and bottom 5 respectively ?

[@WhyMe432532]

Use if statements to break your calculated fields into cases. Then when you do colours you will see the different options.

[@Karan-ms5es]

How can i conditionally format the text color if the value in that columns are negative?

[@dhananjayabk5032]

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.

[@sasmitasahu8599]

awesome...

[@MNEMETH318]

With LAST it seems to include a ZERO position so your Bottom 5 is actually 6 figures highlighted. How is that corrected?

[@jaioh2787]

For calculated field "Last" use the following formula: LAST()+1

[@shashwatjain2937]

I think we can also use First() calculated field in place of Index().

[@willimeet]

if we use a first in this situation numbering part is in negative part

[@shandhingra5242]

Please upload the excel file.

[@bhavnashukla869]

How do I colors code multiple measures

[@27ckoralli]

@Tutorials Point (India) Pvt. Ltd. even I have the same question. I want to add two measures and color the cell background. Please help!

[@dhananjayabk5032]

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.

[@StockSpotlightPodcast]

Bottom 6 are highlighted, not the bottom 5...

[@sharhanalsharhan6966]

Power Bi takes 2 seconds to do all these 7 minutes work

[@yuliyakoskov4081]

your tutorial is good, but we do not need to see you.. it's very destructing.

[@bhanuvishnubhaktula367]

how do you add the column name for Sum(Sales)?