Forum Discussion
Multi row card conditional formatting for all list items
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
=====
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
1 Reply
- isjoycewang
Solution Supplier
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