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
• 7,020 points
501 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
• 8,940 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
8,379 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,776 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,702 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,294 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
• 7,020 points
115 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
• 7,020 points
115 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
• 7,020 points
113 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
• 7,020 points
157 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
• 8,940 points
333 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP