Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
107 | |
88 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |