Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
This is the formatting currently being applied, I can only choose first or last, not a distinct value.
nk its quite a tricky one, thank you for your help!@samwiseowl
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:
I have tried with Fiel Value too but it still won't let me:
For refrence this is the column I am trying to format using:
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?
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.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.