Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Good day,
I am using Multi-row card visual here. I want to have the conditional formatting, if status is "Approved", it will hightlight the item to be green colour. For "Open" it will be Yellow colour and "Rejected" is red colour.
However, if I use this measurement. The result will turn to all green for my visual, if the list of items consists of approved, open and rejected status. I did also used the rule- filter first condition setting, but the result not as what I wanted. Is it the limitation in multi-row card visual?
filter =
var classresult = SELECTEDVALUE('Table_dpt'[column_Status])
var colour = SWITCH(
TRUE(),
classresult = "Approved", "#1AF442",
classresult = "Rejected", "#F42408",
classresult = "Open", "#E3F120",
"White")
return
colour
=====
Solved! Go to Solution.
Hi @ttjy ,
Unfortunately, the conditional formatting seems not working as expected in multi-row cards.
Please consider some workarounds:
1. If your data is simple, use table visual might be more simple to apply formatting.
2. Add UNICHAR icon to show the status.
Some conditional formatting ideas you may refer to this video: https://www.youtube.com/watch?v=CniwSS1c2TU
Hi @ttjy ,
Unfortunately, the conditional formatting seems not working as expected in multi-row cards.
Please consider some workarounds:
1. If your data is simple, use table visual might be more simple to apply formatting.
2. Add UNICHAR icon to show the status.
Some conditional formatting ideas you may refer to this video: https://www.youtube.com/watch?v=CniwSS1c2TU
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 61 | |
| 46 | |
| 40 | |
| 38 | |
| 22 |
| User | Count |
|---|---|
| 176 | |
| 131 | |
| 118 | |
| 82 | |
| 54 |