Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Stacked Column chart conditional formatting not working correctly

Hello Community   I currently have a stacked column chart in which I have WEEK numbers on the axis and FTR roadtankers as value. FTR stands for "first time right" and it represents the percentage ...
Need Help
  • v-joesh-msft's avatar
    v-joesh-msft
    6 years ago

    Hi Anonymous ,

    The conditional formatting takes the difference between the minimum and maximum values as the cardinality of Percent, not the total. You need to adjust it to something like rules below:

    Best Regards,
    Community Support Team _ Joey
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-joesh-msft's avatar
v-joesh-msft
Solution Sage
6 years ago

Hi Anonymous ,

The conditional formatting takes the difference between the minimum and maximum values as the cardinality of Percent, not the total. You need to adjust it to something like rules below:

Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thank you for your help. It works perfect now.