Forum Discussion

MaciejARC's avatar
MaciejARC
Frequent Visitor
4 years ago
Solved

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?

Thanks in advance

M

 

 

  • 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

4 Replies

  • 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

    • amitchandak's avatar
      amitchandak
      Super User

      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