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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

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.