- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Multi Row Card Conditional Formatting
So odd scenario here.
I have a multi row card where I am conditionally formatting the bar colour. If every row has the same colour key then it works fine, as soon as one is different they all turn grey (not one of my options).
See images
Is this an issue with the visualisation or am I being a tool?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.
Blog :: YouTube Channel :: Connect on Linkedin
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Any updates on this functionality. This seems like a bug? ... shouldnt it be possible to implement conditional formating here?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Made an account just to say this defeats the purpose of the multi-row card....
How did they create this but are unable to give cards unique formatting?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi, Is there any solution for this?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.
Blog :: YouTube Channel :: Connect on Linkedin
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

It is actually not a solution indeed, just the representation of reality of another poor PowerBi visual that is not working as everyworld is expecting
😕

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
09-16-2024 11:43 AM | |||
12-29-2024 06:38 AM | |||
10-27-2017 08:57 AM | |||
12-28-2024 03:48 PM | |||
06-01-2021 03:10 AM |
User | Count |
---|---|
86 | |
76 | |
52 | |
39 | |
35 |
User | Count |
---|---|
95 | |
69 | |
55 | |
52 | |
46 |