Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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:
(I also tried using >=90% & <100%; same outcome)
@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...
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
78 | |
63 | |
52 | |
47 |
User | Count |
---|---|
212 | |
82 | |
61 | |
61 | |
60 |