Differentiating Positive and Negative Numbers by Color

Published: 14 Feb 2014
Last Modified Date: 15 Feb 2018


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


Tableau Desktop


  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?