Switch True

[NickM11]

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

[latimeria]

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"

)

[mpraka]

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