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