Forum Discussion
Solved
Conditional Formatting locked to 'Percent' levels
Hi, I'm looking to add conditionally formatted Icon bars to a Matrix, these need to be formatted based on Number rather than percentages. (A simple if this number is positive = green icon, negati...
Hi, OEade
Maybe you can try the following.
Measure:
Measure = DIVIDE(SUM('Table'[Value1]),SUM('Table'[Value2]))Color = IF([Measure]>=0,"Green","Red")Does this match the output you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
In the conditional formtting window, if you have the 'Apply to' set to anything other than just 'Values only', the percent/number field is locked. Change it to values, set your range then change it back to Values and totals.
Sorry should've made it clear in my screenshot. I have 'Apply to' set to Values only already.
Were you able to solve it?
I have the same mistake.
Best regards
