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

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

1 Reply

  • 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