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 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Top Solution Authors