Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
OEade
Frequent Visitor

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).

 

PBI Cond formatting.PNG

 

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

1 ACCEPTED SOLUTION
v-zhangti
Community Support
Community Support

Hi, @OEade 

 

Maybe you can try the following.

Measure:

Measure = DIVIDE(SUM('Table'[Value1]),SUM('Table'[Value2]))
Color = IF([Measure]>=0,"Green","Red")

vzhangti_0-1658825015605.pngvzhangti_1-1658825055272.png

vzhangti_2-1658825087884.png

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.

 

 

View solution in original post

7 REPLIES 7
v-zhangti
Community Support
Community Support

Hi, @OEade 

 

Maybe you can try the following.

Measure:

Measure = DIVIDE(SUM('Table'[Value1]),SUM('Table'[Value2]))
Color = IF([Measure]>=0,"Green","Red")

vzhangti_0-1658825015605.pngvzhangti_1-1658825055272.png

vzhangti_2-1658825087884.png

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
Super User
Super User

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
Super User
Super User

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.

jdbuchanan71
Super User
Super User

@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.

jdbuchanan71_0-1658496603474.png

jdbuchanan71_1-1658496618065.png

 

 

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

 

PBI Cond formatting 2.PNG

Were you able to solve it?

I have the same mistake.

Best regards

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.