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.
Go to Solution.
When you use Diverging it will use shades of defined colors. As of now, we don't able control this.
Is there any other method that I can show earlier mentioned (only) three ranges in bar chart ?
Maybe you can create a calculated column based on the condition like,
Then use this column in legend and change the colors.
Not sure. It will meet your requirement.
Thank you. Will check that way.
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!