Forum Discussion

Akbera1's avatar
Akbera1
Helper I
1 year ago
Solved

Condition formatting

Hey All, i want condition formatting on more then 1 condition. if type A is above 10 then or below 10% is red and type B is above 5% green and below is red. like: Materials      Type            V...
Need Help
Tips and Tricks
  • mdaatifraza5556's avatar
    mdaatifraza5556
    1 year ago

    Hi Akbera1 

    Can you please try this ?

    Create a measure and use conditional formatting.

    ValueColor =
    SWITCH(
        TRUE(),
        MAX('Table'[Type]) = "A" && MAX('Table'[Values]) < 0.10, "#FF0000",  -- Red
        MAX('Table'[Type]) = "A" && MAX('Table'[Values]) >= 0.10, "#00FF00",  -- Green
        MAX('Table'[Type]) = "B" && MAX('Table'[Values]) < 0.05, "#FF0000",  -- Red
        MAX('Table'[Type]) = "B" && MAX('Table'[Values]) >= 0.05, "#00FF00", -- Green
        BLANK()
    )
     
     
     

     

     

    If this answers your questions, kindly accept it as a solution and give kudos.
v-sshirivolu's avatar
v-sshirivolu
Community Support
1 year ago

Hi Akbera1 ,

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you

 

v-sshirivolu's avatar
v-sshirivolu
Community Support
1 year ago

Hi Akbera1 ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions