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.
mdaatifraza5556's avatar
mdaatifraza5556
Super User
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.