Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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 %]) >=...
Need Help
  • negi007's avatar
    negi007
    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 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