Column chart conditional formatting?

[Anonymous]

I use a stacked column chart to see my variance. Sometimes the column has + and sometimes negative values. Is it possible to  highlight the +variance green and the – in red?

Just a simple 0 or higher green below 0 red conditional formatting in the chart?

I also noticed sometimes I have a 0 variance. Is there any option to not show this 0 values?

[Ani1991 · Accepted solution]

Hi @Anonymous 

You can follow the below steps.

1. Under the format options for Stacked Column chart navigate to Data colours.

2. You would see an ellipse button. Click on it and you would see Conditional Formating like below.

 

3. Set the range as below

This will give you the desired output.

Also if you observe for the month of APR the variance was 0 hence I created the following measure and my APR month is not getting displayed on the X axis.

Variance_final = If(SUM('Variance'[Variance]) = 0 ,BLANK(),SUM('Variance'[Variance]))

Hope this helps!!

Thanks,

Ani