how to stop shading colours by value in bar chart

[aravindawi]

Hi,

I want to have only 3 colours based on graph values.

- above 100% -- Green

- 90 % - 99% -- Amber

- below 89% - Red

when I use colour Diverging, it automatically shades colurs in to different colours.

How can I only stick to three colours.

I have attached pictures of my configurations.

Thank you.

[SivaMani · Accepted solution]

@aravindawi,

When you use Diverging it will use shades of defined colors. As of now, we don't able control this.

[aravindawi]

Thank you.

Is there any other method that I can show earlier mentioned (only) three ranges in bar chart ?

[SivaMani]

Maybe you can create a calculated column based on the condition like,

1. >100%
2. 90 - 99%
3. <89%

Then use this column in legend and change the colors.

Not sure. It will meet your requirement.

[aravindawi]

Thank you. Will check that way.