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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Juanpablocl
Frequent Visitor

Conditional formatting problem

I am applying a conditional format based on a Measure called "% Avance Folios". I want it to be green if its over 90%, yellow if its between 70% and 90%, and red if its below 70%. No matter that kind of conditional formatting I use (icons, background/font color) it is applying the color green for values below 90%. Can I get some help?


Example attached:

Juanpablocl_0-1679694129972.png
(I also tried using >=90% & <100%; same outcome)

 

1 REPLY 1
amitchandak
Super User
Super User

@Juanpablocl , if this is a percent measure you need to use the Number in the selection, not percent. And use a number like .9 for 90% (if you have not multiplied it by %)

 

Same way you can create a measure and use that using field value option

 

Switch( True(),

[% Avance Folio] > .9, "Green",

[% Avance Folio] > .7, "Yellow",

"Red"

)

 

How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pan...

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors