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
```

Aug 30, 2018 in Tableau 5,647 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 30, 2018 by
• 10,240 points

0 votes
1 answer

## How to group bins in a tableau histogram?

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

0 votes
1 answer

## How to use a IFF statement in Tableau

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

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

+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

0 votes
1 answer

## Is it possible to split the color by some category within a Waterfall chart?

It's a very easy task to do. ...READ MORE

+2 votes
1 answer

## How to Link Dashboard with URL to enable it to open in the same explorer page

Add this to the end of the ...READ MORE

0 votes
1 answer

## Calculated filed with if-then

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

+2 votes
1 answer

## How can I download tableau workbook with its data from tableau server?

In essence, no. Since the workbook is ...READ MORE

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

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