Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

New Member

Conditional Formatting Bug with Table on Power BI Desktop



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?

Super User
Super User

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

View solution in original post

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.

Super User
Super User

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

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors