cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
aravindawi Frequent Visitor
Frequent Visitor

how to stop shading colours by value in bar chart

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.

 

power bi.JPGpower bi2.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
SivaMani Senior Member
Senior Member

Re: how to stop shading colours by value in bar chart

@aravindawi,

 

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

4 REPLIES 4
SivaMani Senior Member
Senior Member

Re: how to stop shading colours by value in bar chart

@aravindawi,

 

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

aravindawi Frequent Visitor
Frequent Visitor

Re: how to stop shading colours by value in bar chart

Thank you.

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

SivaMani Senior Member
Senior Member

Re: how to stop shading colours by value in bar chart

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 Frequent Visitor
Frequent Visitor

Re: how to stop shading colours by value in bar chart

Thank you. Will check that way.

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 155 members 2,157 guests
Please welcome our newest community members: