The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi Community,
I have a multi-column table (values and measures) and I am trying to apply conditional font formatting by a rule to one column which is a measure. It works...partially and I can't seem to reason out why. Attached is a snip of the results and the rule conditions. Essentially green for 100%, Yellow for 90-99%, and red below 90%. The measure is formatted as a percentage.
As you can see, it applies the yellow to one value in the range 90-99 but not to the others.
Same thing if I move to icons.
Any thoughts here?
That's pretty odd. Curious what would happen if you based it on decimal numbers instead of Percent, so 1, .90, .99, etc.
Thanks for the suggestion Greg.
I made the switch to both the measure (decimal number format) as well as changing the rules to decimals and "number". I got the same result as my original.
However!!
As I started switching it back, I changed the measure back to % and they appeared correctly! Note that I did NOT change the rule set from decimals and 'Number"!
Like you said, odd behavior.
Thank you for the response.
Ah, potentially mystery solved, it is the percent of the range of your data, so perhaps you have some data that is > 100% essentially? Watch the video here:
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-july-2019-feature-summary/#percentRules
So weird...
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
96 | |
80 | |
62 | |
56 |
User | Count |
---|---|
256 | |
120 | |
112 | |
83 | |
71 |