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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Ieutomic
Frequent Visitor

Conditional Formatting of multi card visual in power BI

Hi there,

 

I am currently developing a dashboard to show inspections done, there is a traffic light rating system, Red, Orange Green, depending on if the inspection was good, ok, or bad. I want the background of each card to change to red, orange, or green accordingly.

 

I am doing this using conditional formatting of the fill colour. But I can only do it using the First or Last value in the set, does anyone know why this might be? I have been able to do it in a table no problem but for some reason the multi card visual isn't liking it. Could anyone please suggest a fix around for this? Thanks!

 

Ideally I want the multi card visual on the left to have red orange or green boxes similar to the formatted table on the right

Screenshot 2025-03-24 121308.png

 

 

This is the formatting currently being applied, I can only choose first or last, not a distinct value.

Screenshot 2025-03-24 121857.png

 

 

4 REPLIES 4
Ieutomic
Frequent Visitor

nk its quite a tricky one, thank you for your help!@samwiseowl

SamWiseOwl
Super User
Super User

Hi @Ieutomic 
Which visual are you using, is it a custom visual?
Can you take a screen shot from the visualisation pane please.

 

You should be able to choose FieldValue instead of rules and select that column.

Alternatively you may be able to use a measure that returns the single item colour.

Colour measure =
SelectedValue(table[TIActionCategory])

 


If you are happy with this answer please mark as a solution for others to find !

Kudos are always appreciated! Check out our free Power BI video courses.

Hi @SamWiseOwl ,

 

It is just the in built multi-row card:

Ieutomic_0-1742823650355.png

I have tried with Fiel Value too but it still won't let me:

Ieutomic_1-1742823731667.png

For refrence this is the column I am trying to format using:

Ieutomic_2-1742823768825.png

I think a measure might not be dynamic enough, a measure will only represenbt a single value right?

Ahh you said "multi card visual" and I wasn't sure if that was something different.

Unfortunetly I don't think that visual supports what you are trying to do.

 

Have you tried the New Card visual?

SamWiseOwl_0-1742823993671.pngSamWiseOwl_1-1742825421813.png

 


If you are happy with this answer please mark as a solution for others to find !

Kudos are always appreciated! Check out our free Power BI video courses.

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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

Top Solution Authors