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
MaciejARC
Frequent Visitor

column conditional formatting in matrix

hi,

I need to set up conditional formatting only for columns C:F (always red font) in a matrix visual.

How can I do solve this?

MaciejARC_0-1637912459109.png

Thanks in advance

M

 

 

1 ACCEPTED SOLUTION

@MaciejARC , use this measure 

 

color =

if( Max(Table[Bucket]) in {"60 Days", "180 Days", "365 days"} , "red", "black")

 

correct column name and values as per need

View solution in original post

4 REPLIES 4
MaciejARC
Frequent Visitor

This is perfect! Thank you!

MaciejARC
Frequent Visitor

Thanks, but how to apply it only to columns C:F?

@MaciejARC , use this measure 

 

color =

if( Max(Table[Bucket]) in {"60 Days", "180 Days", "365 days"} , "red", "black")

 

correct column name and values as per need

amitchandak
Super User
Super User

@MaciejARC ,

 

Create a measure

 

color = "red"

 

and use that is conditional formatting for all 4 columns using the field value option

How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4

 

 

Also you can check field formatting and color for that

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.