Forum Discussion
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, negative = red icon)
However, when attempting this I see that the formatting levels are locked to a combination of Number and Percent (see below).
I have been able to change these to number for another matrix in my report where the formatting is working correctly. I have checked my measures formatting and flicked between General, decimal and whole number but none have solved this issue.
How am I able to change all of these drop-downs to set the format levels to 'Number'?
Many thanks,
Ollie
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.
7 Replies
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
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.
Very strange, I am not able to replicate that behaviour. Can you try clearing the conditional formatting from the table then adding it back in?
I have tried this already unfortunately, even when recreating a new table I'm still faced with the issue.
This sounds like a bug to me. You should submit it as an issue, perhaps the PowerBI team has a fix.
https://community.powerbi.com/t5/Issues/idb-p/Issues
