Conditional format Matrix Column

[cottrera]

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

[cottrera]

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%

[amitchandak · 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" )