Forum Discussion

NickM11's avatar
NickM11
New Member
3 years ago

Switch True

I wanted to create a conditional format for changing the colour of a guage, and have had success with 2 variations, but not with the third.

I can set the colour if value is less than 70% "Red", or greater than 90% "Green", however I don't know how to set the 71%-89% to "Orange".

 

Please can you help.

 

This is what I tried

 

Switch = SWITCH(TRUE(), SUM('full volumes'[Total BB])<(0.7*SUM(Accounts[BB TD])),"Red",SUM('full volumes'[Total BB])>(0.9*SUM(Accounts[BB TD])),"Green","Orange")
 
Thanks
 

 

Need Help

2 Replies

  • mpraka's avatar
    mpraka
    Advocate II
    3 years ago

    Hi,

     

    You can also try/do it with Conditional formating in Fill colors --> Rules --> and selecting the values fields.

    Here i have just given few sample data for color logic between 0-10 and you can see 6 is falling under yellow.

    Thank you
    Prakash

  • latimeria's avatar
    latimeria
    Solution Specialist
    3 years ago

    Hi NickM11 ,

    Switch stop when the first condition is met.

    So you can do:

    switch(

      true(),

    x<0.7,"Red",

    x<0.9, "Orange",

    "Green"

    )