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

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.

Reply
Anonymous
Not applicable

Conditional Formatting Error with Shape Map

Hello community,

I am having an issue when I am using conditional formatting for the colors on a shape map. 

I am using a measure (Utilization %) to determine the state's color (map of U.S.). The "Utilization %" measure finds the customer transactions with a certain label, and divides it by the total number of transactions. The map colors are where the Utilization % fits into a category: Green (90% or greater), Yellow (70 - 90%), and Red (under 70%).

However, certain states' tooltip is showing 92%, but will display yellow. Or 88% and green. There are no filters being applied to the calculation, but using a dimension table to filter the states can cause some of them to change color. I think something weird is happening in the filter context.

Any help would be appreciated, thanks! 



1 ACCEPTED SOLUTION
Anonymous
Not applicable

Thanks, but I figured it out. I put the rules in as a decimal, not a percentage. For some reason PowerBI got messed up from it.

View solution in original post

2 REPLIES 2
HotChilli
Super User
Super User

If you provide a sample pbix I'll have a look at it

Anonymous
Not applicable

Thanks, but I figured it out. I put the rules in as a decimal, not a percentage. For some reason PowerBI got messed up from it.

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

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.