Multi Row Card Conditional Formatting

Hi MCornish 

Unfortunately that's the way conditional formatting works on Multi Row Card.  It's not really working as you'd expect, and as a result it's not very useful.

What's it's actually doing is looking at all the values in the Colour Key column.  If you set your CF Rules so that you want to apply different colours to different values (as you have) - PBI doesn't know what to do because some values in the Colour Key column are 0 and some are 1.  It can't apply 2 rules to all the card rows, so it makes them grey.

If you only have 1 CF Rule, or you choose to format by an aggregation like Minimum, so you set it to colour the bars based on the Minimum of the Colour Key

Then it makes all bars red because the min in the Colour Key column is 0, and there's a rule to match that value.

Likewise if you format for the max value to be 1 it can find 1 in the Colour Key column and find a matching rule, so all bars are green.

It's not clear this is how it works and it's not very useful.

Regards

Phil