Show Positive and Negative Colors in Chart

Published: 19 Apr 2013
Last Modified Date: 24 Apr 2017


How to create a chart showing positive numbers in green and negative numbers in red.


Option 1

  1. Place the desired measure on the Color shelf.
  2. Right-click the caret in the upper right corner of the Color card and select Edit Colors....
  3. Check the Stepped Color box and choose 2 steps.
  4. Click OK.

Option 2

  1. Create a calculated field similar to the following:
    IF SUM(Profit)>0 then 'Positive'
    ELSE 'Negative'
  2. Place the above calculation on the color shelf.
  3. Edit the colors as desired.

Additional Information

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