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.
User | Count |
---|---|
2 | |
2 | |
2 | |
1 | |
1 |