KNOWLEDGE BASE

Show Positive and Negative Colors in Chart


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

Question

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

Answer

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'
    END
  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?