Forum Discussion
Anonymous
5 years agoNot applicable
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 %]) >=...
- 5 years ago
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
v-luwang-msft
5 years agoCommunity Support
Hi Anonymous ,
Could you pls share your pbix file? Remember to remove condient data.
Best Regards
Lucien