Conditional Formatting Bug with Table on Power BI Desktop

[edwardgurton]

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?

[edwardgurton]

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 · Accepted solution]

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