Tableau - Conditional Formatting

No video

Tableau - Conditional Formatting

Рет қаралды 117,511

Күн бұрын

Tableau - Conditional Formatting
Lecture By: Mr. Pavan Lalwani, Tutorials Point India Private Limited
Get FLAT 10% on latest Tableau certication course(Use Coupon "KZfaq"):
bit.ly/31H9qYE
Watch More Videos at:
www.tutorialsp...
#tableau #tableautraining #tableaututorial #TutorialsPoint #Tutorix #OnlineCourses

Пікірлер: 42

@TutorialsPoint_ Жыл бұрын

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

@lanvinsgivenchy5421 Жыл бұрын

Excellent video , thanks for sharing

@arifsheikh2163 4 жыл бұрын

Understood and Nicely explained

@antoniolupen6138 6 ай бұрын

three hurrahs for this man !!

@07jfdr6u Жыл бұрын

Great 👍

@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.

@muralid6116 2 жыл бұрын

Nice explanation

@Sports-yz1fg 3 жыл бұрын

thank you.FA.

@jaioh2787 4 жыл бұрын

really great video! thank you!!!!

@WhyMe432532 3 жыл бұрын

You make amazing videos man!

@sj8648 4 жыл бұрын

Thank you Sir!!!

@TheDistractionStudio 6 жыл бұрын

Thank You! Very helpful

@aryansena7290 3 жыл бұрын

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

@prasadvaram 5 жыл бұрын

can also be achieved using Rank()

@sasmitasahu8599 6 жыл бұрын

awesome...

@EASYTIGER10 6 жыл бұрын

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 3 жыл бұрын

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 2 жыл бұрын

@@KeithFlint350 Thank you!

@franknicaragua 2 жыл бұрын

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!

@sowyanss8702 2 жыл бұрын

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

@JonathanJournal 5 жыл бұрын

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

@ferideymkli 2 жыл бұрын

how can I download the dataset?

@HenryHeung0817 4 жыл бұрын

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

@WhyMe432532 3 жыл бұрын

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

@piyushgaur9501 6 жыл бұрын

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 5 жыл бұрын

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

@cuat98 5 жыл бұрын

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

@yashika0511 4 жыл бұрын

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

@Karan-ms5es 5 жыл бұрын

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

@dhananjayabk5032 5 жыл бұрын

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.

@MNEMETH318 4 жыл бұрын

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

@jaioh2787 4 жыл бұрын

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

@shashwatjain2937 6 жыл бұрын

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

@willimeet 2 жыл бұрын

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

@shandhingra5242 6 жыл бұрын

Please upload the excel file.

@bhavnashukla869 6 жыл бұрын

How do I colors code multiple measures

@27ckoralli 6 жыл бұрын

@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 5 жыл бұрын

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.