Forum Discussion
Problem with a Measure Used for Conditional Formatting
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 there is another way of creating measures.If possible, please try below option instead of hard coding the color, use 1,2, 3 . Then instad of field value use rules in your conditional formatting. Please refer to below screenshot. This will also give you more control on the color scale you wish to use.
Color Measure = Switch(true(), MAX('WTCV'[OBL %]) >=.98 , 1,
MAX('WTCV'[OBL %]) >=.92 , 2,
MAX('WTCV'[OBL %]) >=0 , 3
)
Do let me know if you still face any issue.
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 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