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