KNOWLEDGE BASE

Differentiating Positive and Negative Numbers by Color


Published: 14 Feb 2014
Last Modified Date: 31 May 2017

Question

How to show negative numbers as red and positive numbers as black.

Environment

Tableau Desktop

Answer

  1. Drag "Product Sub-Category" to the Rows shelf.
  2. Drag "Profit" to Colors.
  3. Drag "Profit" to Text.
  4. Click Color on the Marks card, and select Edit Colors...
  5. Choose "Custom Diverging" as a Palette (located near the bottom of the Palette list) 
  6. Tick the Stepped Color option and change the number to 2 Steps.
  7. Tick the Use Full Color Range option.
  8. To change the colors, click the squares at either end of the range and set one as red and the other as black.
  9. Click OK

Additional Information

The range of the color is determined by the number of "Stepped" selected. For more information about Quantitative Palette, see Color Properties.

To view these steps in action, see the video below: 
Did this article resolve the issue?