Color formatting conditionally in a tableau list

0 votes

When the worry filter is true, I'm attempting to conditionally format the progress till date to red for dates in the end date that have already passed or are less than the current date.

The screenshot is as follows:

enter image description here

Please assist me in making the progress column red for end dates that have past or are less than the current date when the worry filter is set to yes.

Apr 7 in Tableau by Vaani
• 5,040 points
19 views

1 answer to this question.

0 votes

This is one method for colouring a column depending on a different value (conditional formatting).

enter image description here

  1. Data set looks like following:

enter image description here

  1. Create a calculated field which will hold the color condition (I assume your data is in date format and not string):

    IF [Concern] = "Yes" AND [End Date] < TODAY() THEN "RED" ELSE "" END

  2. Create a dummy calculated field:

This is one way to color a column based another value (conditional formatting).

enter image description here

  1. Data set looks like following:

enter image description here

  1. Create a calculated field which will hold the color condition (I assume your data is in date format and not string):

    IF [Concern] = "Yes" AND [End Date] < TODAY() THEN "RED" ELSE "" END

  2. Create a dummy calculated field:

enter image description here

  1. We create a second dummy:

enter image description here

  1. We add the dummy columns to the "columns" at the top

enter image description here

  1. Make them to "Dual Axis"

enter image description here

  1. Then click on "Marks" and "All". Drag color and drag it down to Color (1 in picture) and choose text (2 in picture)

enter image description here

  1. Then drag the Progress column to the text field

enter image description here

  1. Time to adjust layout. Right click and choose "Edit Axis"

enter image description here

9.1 Remove "Title" from "Axis Titles"

enter image description here

9.2 Remove the ticker marks

enter image description here

  1. Choose the upper header and change the title

enter image description here

and remove the tickers

enter image description here

  1. Then adjust the header space by dragging the line

enter image description here

answered Apr 7 by Neha
• 6,260 points

Related Questions In Tableau

0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,230 points
7,938 views
+1 vote
1 answer

Is it possible to define a color code scheme just for one column in Tableau?

Follow the below steps : Remove your current ...READ MORE

answered Jul 24, 2018 in Tableau by Atul
• 10,230 points
1,592 views
0 votes
1 answer

How to group bins in a tableau histogram?

One of the simple way is by ...READ MORE

answered Apr 3, 2018 in Tableau by xyz
• 1,560 points
5,189 views
0 votes
1 answer

How to use a IFF statement in Tableau

Use this syntax -  IIF(([Avg_sale] > [Today]),STR([Avg_sal ...READ MORE

answered Apr 5, 2018 in Tableau by QueenBee
• 1,820 points
1,158 views
0 votes
0 answers

Using Python and Tableau in conjunction with one another

Is it possible to mix Python visualisations ...READ MORE

Feb 28 in Tableau by Vaani
• 5,040 points
47 views
0 votes
0 answers

Tableau Desktop Inside Tableau Server

Is there an executable for Tableau Desktop ...READ MORE

Feb 28 in Tableau by Vaani
• 5,040 points
65 views
0 votes
0 answers

Tableau Map view Continent List

I've been attempting to tidy up my ...READ MORE

Feb 28 in Tableau by Vaani
• 5,040 points
32 views
0 votes
0 answers

Downloading tableau workbook from tableau server with data

I'm brand new to tableau server. I ...READ MORE

Feb 28 in Tableau by Vaani
• 5,040 points
70 views
0 votes
1 answer

Is there a Loop function in Tableau Prep? (Problem written below)

Hey, Prep lacks a built-in looping function, ...READ MORE

answered Mar 28 in Tableau by Neha
• 6,260 points
60 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP