Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
ttjy
New Member

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. 

 

ttjy_0-1698731340120.png

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
=====

ttjy_1-1698731478916.png

 

1 ACCEPTED SOLUTION
isjoycewang
Super User
Super User

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.

isjoycewang_0-1698766903518.png

 

Some conditional formatting ideas you may refer to this video: https://www.youtube.com/watch?v=CniwSS1c2TU

View solution in original post

1 REPLY 1
isjoycewang
Super User
Super User

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.

isjoycewang_0-1698766903518.png

 

Some conditional formatting ideas you may refer to this video: https://www.youtube.com/watch?v=CniwSS1c2TU

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.