Hi
I have a Matrix visual that I would like to only conditional format the background colour for the % column with the header 'Yes' as highlighted below. Can you please tell me is this is possible wit DAX
0%-98% = Red
98%-99% Orange
99%-100% = Green
thank you
Richard
1 ACCEPTED SOLUTION
@cottrera , Create a color measure and use that in conditional formatting using filed value option
Color = if(Max(Table[Job completed with]) = "Yes", Switch(True() ,
[%] <= 98% ,"Red",
[%] <= 99% ,"Orange",
[%] <= 100% , "Green"), "white" )
Thank you amitchandak for your quick response this measure worked fine. I just needed to change the % to numbers. For example 1 instead of 100%
@cottrera , Create a color measure and use that in conditional formatting using filed value option
Color = if(Max(Table[Job completed with]) = "Yes", Switch(True() ,
[%] <= 98% ,"Red",
[%] <= 99% ,"Orange",
[%] <= 100% , "Green"), "white" )
