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
Anonymous , Yiu can face issues when you do have text type of measure. Just try to type Obs in search and then try to select.
or
Can you share a sample pbix after removing sensitive data.