Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Column chart conditional formatting?

  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...
Need Help
  • Ani1991's avatar
    Ani1991
    6 years ago

    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

Ani1991's avatar
Ani1991
Resolver III
6 years ago

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