Conditional Formatting locked to 'Percent' levels

[OEade]

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

[v-zhangti · Accepted solution]

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.

[jdbuchanan71]

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

[jdbuchanan71]

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?

[OEade]

I have tried this already unfortunately, even when recreating a new table I'm still faced with the issue.

[jdbuchanan71]

@OEade 

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.

[OEade]

Sorry should've made it clear in my screenshot. I have 'Apply to' set to Values only already.

[Syndicate_Admin]

Were you able to solve it?

I have the same mistake.

Best regards