Forum Discussion

andrea100's avatar
andrea100
Icon for Helper I rankHelper I
1 year ago

Problems implementing conditional formatting on bar chart with grand total count measures

Hi, I've posted a question related to this before(https://community.fabric.microsoft.com/t5/Desktop/Conditional-formatting-on-bar-chart-for-each-bar-Is-this/m-p/4257232#M1337717) I was able to lea...
Need Help
andrea100's avatar
andrea100
Icon for Helper I rankHelper I
1 year ago

Hello community, I am still having issues implementing this. I've been playing around with the solution that was accepted, but I noticed that in some cases the conditional formatting doesn't work as expected (cases where there is a sum). I noticed it will not take the sum into account.

 

I am using this solution for conditional formatting:

Color = 
SWITCH(
    TRUE(),
    [Below%]>15,"red",
    [Marginal%]+[Below%]>40,"yellow",
    [Meets%]+[Exceeds%]>90,"orange",
    [Exceeds%]>30,"green"
)

 

I have many instances where Marginal+Below>40 and Meets+Exceeds>90 but the bar doesn't change colour. 

 

Help and guidance is much appreciated.