How to apply color condition to only one measure value

Published: 04 Jul 2023
Last Modified Date: 07 Jul 2023

Question

How to apply color condition to only one measure value.

In this case, suppose you want to apply the color condition only to Profit and not to Sales.
The color condition should be "Blue" if Profit is greater than or equal to 0, and "Red" if Profit is negative.

<Current Behavior>
User-added image

<Desired Behavior>

Environment

Tableau Desktop

Answer

Please follow along with the attached sample workbook to the right of this text in the Attachments section.

<STEP 1>
-Creating Crosstab-
1. Connect to Sample Superstore from Tableau Desktop.
2. Drag [Order Date] and [Category] to Rows.
User-added image

3. Drag [Region] to Columns.
User-added image

4. Drag [Profit] to Text on Marks.
User-added image

5. Drag [Sales] to crosstab as follows.
User-added image

-Set the Color Condition to Profit-
6. Create a new calculated field as following,
Name :Profit Color Condition
Calculation : IF SUM([Profit])>=0
THEN "BLUE"
ELSE "RED"
END
7. Drag [Measure Names] to Color.
User-added image