Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
Hi, below (in order) are what my report''s percentage columns look like after trying to apply a red font color if pct is < 0. The 2nd has mixed results. The 3rd wont even take a rule. Can someone help? The dax calculation is generally recent to date figure / previous to date figure - 1.
Solved! Go to Solution.
@db042190 , The third one use one as percent (3td box) and one as number . In case of percent measure, all should number
Also, you can use measure based conditional formatting using field value
Power BI why Rule Based conditional formatting do not work with percent column: https://youtube.com/shorts/UaQX0yOeAWE
if([Your measure] < 0, "Red", "Green")
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...
@db042190 , The third one use one as percent (3td box) and one as number . In case of percent measure, all should number
Also, you can use measure based conditional formatting using field value
Power BI why Rule Based conditional formatting do not work with percent column: https://youtube.com/shorts/UaQX0yOeAWE
if([Your measure] < 0, "Red", "Green")
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...
| User | Count |
|---|---|
| 50 | |
| 37 | |
| 31 | |
| 22 | |
| 19 |
| User | Count |
|---|---|
| 135 | |
| 102 | |
| 60 | |
| 36 | |
| 35 |