Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
This is perfect! Thank you!
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
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
User | Count |
---|---|
98 | |
90 | |
83 | |
70 | |
67 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |