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 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 table

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