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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
edwardgurton
New Member

Conditional Formatting Bug with Table on Power BI Desktop

Hi

 

I am seeing occasional instances where a rule based conditional formatting is returning the wrong colours.

 

I have a table visual, which is effectively a league table. Countries have a measure called "Master Score Number" and their score is colour coded according to the band that it is in, with a different colour for a score of 0-20, 20-40, 40-60 etc...

 

Mostly, the formatting works correctly, but occasioanlly I see a country with the wrong colour. I also have data bars for the same measure and my table is sorted by the measure, so I do not believe that the issue is with the measure.

 

Moreover, when I use a colour scale for the same table and measure, the formatting all works correctly.

 

example 1example 1example 2 (different selection)example 2 (different selection)

Note: I noticed whilst preparing these screenshots that I am mixing "Number" and "Percent". I have already corrected this, but it has not resolved the issue.

colour scale formatting works on same tablecolour scale formatting works on same table

 

Is this a known bug? And is there a known workaround?

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@edwardgurton , I think in place of percent, the third box in condition. It should be number

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

2 REPLIES 2
edwardgurton
New Member

Thanks, I updated all the formatting as number and this time it works. 

 

This doesn't itself explain the result that you see there. For example, why is 64 black but 66 pink? 

 

But it solves my problem for now.

amitchandak
Super User
Super User

@edwardgurton , I think in place of percent, the third box in condition. It should be number

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.