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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
agd50
Helper V
Helper V

Conditional Formatting with percentages - Help

agd50_3-1678240177134.png

 

 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.

 

 

 

3 REPLIES 3
RaocoSolutions
Regular Visitor

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.

tackytechtom
Super User
Super User

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! linkedIn

#proudtobeasuperuser 

I thought of this too, I will give it a go and let you know.

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.