Color formatting conditionally in a tableau list

Question

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:

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.

Answer 1

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

1. Data set looks like following:

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

1. Data set looks like following:

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:

1. We create a second dummy:

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

1. Make them to "Dual Axis"

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

1. Then drag the Progress column to the text field

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

9.1 Remove "Title" from "Axis Titles"

9.2 Remove the ticker marks

1. Choose the upper header and change the title

and remove the tickers

1. Then adjust the header space by dragging the line