Forum Discussion
Problem with a Measure Used for Conditional Formatting
Please help! I successfully used the following measure for backgorund conditional formatting: Color Measure = Switch(true(), MAX('WTCV'[OBL %]) >=.98 , "light green", MAX('WTCV'[OBL %]) >=...
Anonymous
1. this is how i created measure in this case
Color Measure = Switch(true(), MAX('Table'[OBL %]) >=.98 , 1,MAX('Table'[OBL %]) >=.92 , 2,MAX('Table'[OBL %]) >=0 , 3)2. then i used it in the conditional formatting like below3. below is the output
I am also attaching pbix file for your. there are two measure in the file for background color based on condition.
let me know if it helps you. thanks
negi007 Thank you! This sounds like a great method, however, I am not sure how you are using the measure in this case.
Anonymous
1. this is how i created measure in this case
Color Measure = Switch(true(), MAX('Table'[OBL %]) >=.98 , 1,
MAX('Table'[OBL %]) >=.92 , 2,
MAX('Table'[OBL %]) >=0 , 3
)
2. then i used it in the conditional formatting like below
3. below is the output
I am also attaching pbix file for your. there are two measure in the file for background color based on condition.
let me know if it helps you. thanks