Gauge shows wrong color based on value

[TechR21]

Hi,

I have a gauge with 3 color rules;

yet my result is this:

Any idea? when i delete the last rule, between 0-85 i get this:

[MohammadLoran25 · Accepted solution]

Hi

You have to change your numbers in conditional formatting pop-up as below:

1

0.9

0.85

0

Right now your number are less than 1 (between 0% and 100%) so it goes to the red color.

If my answer solves your problem, please accept it as a solution so the others could find the answer easily.

Regard,

Loran

[MohammadLoran25 · Accepted solution]

Hi

You have to change your numbers in conditional formatting pop-up as below:

1

0.9

0.85

0

Right now your number are less than 1 (between 0% and 100%) so it goes to the red color.

If my answer solves your problem, please accept it as a solution so the others could find the answer easily.

Regard,

Loran

[TechR21 · Accepted solution]

Yes this was it. I did this before on a report but couldnt remember, thanks!