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!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I want to highlight how some percentages are lower (meaning a bad thing) but it doesn't look like conditional formatting will allow me to make a rule that goes if percentage is this amount then go red icon - because it sums the value which is not what I want.
Looks like the field you are using is a column.
You need to create a measure for % calculation and then use that measure as filed, as measure is summarised by default and only returns one value, power bi will not ask you to do summarization.
Hi @agd50 ,
Would it work if you write 0.33 instead of 33, and 0.67 instead of 67 and so on in your conditional format settings?
Let me know 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
| Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
| Also happily accepting Kudos 🙂 |
| Feel free to connect with me on LinkedIn! | |
| #proudtobeasuperuser | |
I thought of this too, I will give it a go and let you know.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!