Forum Discussion
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
- amitchandakSuper User
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
- MaciejARCFrequent Visitor
Thanks, but how to apply it only to columns C:F?
- amitchandakSuper 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
- MaciejARCFrequent Visitor
This is perfect! Thank you!