Color formatting conditionally in a tableau list

Question

I am trying to conditionally format the progress till date to red for the date in the end date which has already passed or which is lesser than the current date and when the concern filter is yes.

Below is the screen shot:

Please help me how do I Make the progress column red for end dates which have passed or lesser than the current date and when the concern filter is yes

Answer 1

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

1. Data set looks like following:

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

3. Create a dummy calculated field:

4. We create a second dummy:

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

6. Make them to "Dual Axis"

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

8. Then drag the Progress column to the text field

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

9.1 Remove "Title" from "Axis Titles"

9.2 Remove the ticker marks

10. Choose the upper header and change the title

and remove the tickers

11. Then adjust the header space by dragging the line