Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
dd88
Post Patron
Post Patron

Visual Multi-row Card way to change colour for individual the text/values

I created this power bi report over 1.5 year ago.  At the time I used the visual Card. The Card is static, if you click on the card it does not link to the table, and the table doesnt update to the card status selection.

 

Visual Multi-row Card - 01.png

 


The new Visual Multi-row Card is great. In the multi-card when you click on a Status, the Table updates to display items of the status. 

 

The users like how the Card Status colour matches the Status in the Table.

 

In the visual Multi-row Card is there a way to change the colour of the text/values for individual values/text?

 

Also can the card Status colours be pre-set? for example at the moment there is no Status Completed. In the data source if users change an item status to Completed, will the Visual Multi-row Card automatically show Completed as colour green. Or will I manually have to update the report each time? Or is there another way to solve this?

 

 

TIA

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

Hi @dd88 

What allows the interactivity of the cards with the table is the context provided by the category (thanks to the fact that it's not a separate measure for each status).

The limitation of the card visualizations we have is that we can't apply conditional formatting based on categories, only on measures. Therefore, in this visualization, there's no way to both define colors based on status and maintain interactivity.

In terms of alternatives, there is a visualization type called "Multi Info Cards" which allow conditional formatting of the background based on the category.
For example, I have a sample file with sales and age groups and want to modify the separate colors of the age group.

I created a needed dax of coloring:

Age group color =
  SWITCH(SELECTEDVALUE('Customers'[Age group]),
  "35-44","#f4a582",
  "25-34","#fdae61",
"#b2abd2")
If I will try to use it in the score card , nothing will change :

Ritaf1983_0-1723174580464.png

 

The same logic with "Multi Info Cards" will give us the results:

Ritaf1983_1-1723174598195.pngRitaf1983_4-1723174828970.png

 


The drawback of this visualization is that it has very limited design options, and the color settings apply only to the background color.

 

If you still decide to use it, here is its image in the marketplace:

Ritaf1983_4-1723173544994.png
 

Other alternative is to generate something similar from the core table :

 

Ritaf1983_2-1723174686345.png

 


 
And the last idea use rectangles with the visual :


 

Ritaf1983_3-1723174743257.png

 

The pbix with all the examples is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

 

 
Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

5 REPLIES 5
cath1ynn
Resolver II
Resolver II

An alternative would be the Cards (new) visual that allow you to display multiple measures in a grid.

 

cath1ynn_0-1723179534292.png

 

cath1ynn_4-1723179996330.png

 

 

There are pros and cons to this visual as well.

 

Pros:

  • You can customise the Background/Border/Accent bar/Callout values colour for each measure.

 

cath1ynn_2-1723179704050.png

  • Instead of showing (Blank) when there is no data, you can choose what to show

cath1ynn_3-1723179820081.png

  • You can use Reference labels to provide more information (e.g. when compared to previous month, or call out for a specific client)

 

Cons:

  • You would need to create a measure for each status and add that to the Data pane

cath1ynn_1-1723179683531.png

  • You can't click on each Status/measure to filter other visuals on the same page

 

Thank you @cath1ynn  thats great ..

   

dd88
Post Patron
Post Patron

Thank you @Ritaf1983  thats great, they are great solutions & possiblities. I will look at the sample template provided to try and work out how best to use

 

Thank you again 

Happy to help 🙂

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
Ritaf1983
Super User
Super User

Hi @dd88 

What allows the interactivity of the cards with the table is the context provided by the category (thanks to the fact that it's not a separate measure for each status).

The limitation of the card visualizations we have is that we can't apply conditional formatting based on categories, only on measures. Therefore, in this visualization, there's no way to both define colors based on status and maintain interactivity.

In terms of alternatives, there is a visualization type called "Multi Info Cards" which allow conditional formatting of the background based on the category.
For example, I have a sample file with sales and age groups and want to modify the separate colors of the age group.

I created a needed dax of coloring:

Age group color =
  SWITCH(SELECTEDVALUE('Customers'[Age group]),
  "35-44","#f4a582",
  "25-34","#fdae61",
"#b2abd2")
If I will try to use it in the score card , nothing will change :

Ritaf1983_0-1723174580464.png

 

The same logic with "Multi Info Cards" will give us the results:

Ritaf1983_1-1723174598195.pngRitaf1983_4-1723174828970.png

 


The drawback of this visualization is that it has very limited design options, and the color settings apply only to the background color.

 

If you still decide to use it, here is its image in the marketplace:

Ritaf1983_4-1723173544994.png
 

Other alternative is to generate something similar from the core table :

 

Ritaf1983_2-1723174686345.png

 


 
And the last idea use rectangles with the visual :


 

Ritaf1983_3-1723174743257.png

 

The pbix with all the examples is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

 

 
Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors