Forum Discussion
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
This is the formatting currently being applied, I can only choose first or last, not a distinct value.
4 Replies
- SamWiseOwl
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])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?
- SamWiseOwl
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?
nk its quite a tricky one, thank you for your help!@samwiseowl
