Adding colors to a cell in Tableau

0 votes

What I want?

Color code cells in tableau on a particular column based on values from other columns. Is that possible ? 

I know that in general we can use conditional formatting on Excel to do this. But, I wanted to find out if there is a tableau way of achieving this, this helps me automate my report.

So, here is an example, which shows the color-coded Goal_diff_measure1 cells, based on corresponding values from pct_diff_measure1

logic :

pct_diff_measure1> 0 and pct_diff_measure1 <=10, yellow
pct_diff_measure1 >10, red

enter image description here

Aug 29, 2018 in Tableau by Atul
• 10,240 points
510 views

1 answer to this question.

0 votes
Yes its possible,

Your logic will only color the font but not back ground so try below process.

Instead of using cross tab you need to use columns one by one so that we can manipulate the background colour effectively.

Giving example for one column this you can extend to any number of columns:

Create a calculated field and place 0 and save as Column1.

Place column1 on columns part and then place the pct_diff_measure1 on label of marks of column1.

Replicate the same column 1 to the side of first column and then change the chart type to square, Then in marks increase the size of square to maximum.

Now create a dual axis which will combine square and value

Push marks to front and square to back

Write the conditional formula for colour and place on colour of square.

Repeat the same to all columns.
answered Aug 29, 2018 by Atul
• 10,240 points

Related Questions In Tableau

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,550 points
1,275 views
0 votes
1 answer

How to use a IFF statement in Tableau

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

answered Apr 5, 2018 in Tableau by QueenBee
• 1,810 points
191 views
0 votes
1 answer

How to calculate the percent of records within a group in tableau?

 You can click the measure SUM(Number of Records) and ...READ MORE

answered May 8, 2018 in Tableau by Atul
• 5,530 points
270 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 23, 2018 in Tableau by Atul
• 10,240 points
176 views
0 votes
1 answer
+1 vote
1 answer
0 votes
1 answer

Calculated filed with if-then

Below is the required code:  IF (NOT ISNULL([test2])) ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
101 views
+2 votes
1 answer
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,240 points
2,228 views
0 votes
1 answer

How to count occurrence of value and percentage of a subset in tableau public?

Although it sounds like a fairly easy ...READ MORE

answered Jun 5, 2018 in Tableau by Atul
• 10,240 points
3,637 views