Reply
Frequent Visitor
Posts: 11
Registered: ‎04-30-2018

Help with Bar Chart

[ Edited ]

Hi All,

 

I am trying to constuct a bar chart that basically says if the (Hours) are greater than 2000 then give it a red colour and have it at the top, however if the hours is less that 2000 than flip it and have and give it a green color. Basically setting 2000 as my x-axis value.

 

Could someone please provide me with some guidance on how to achieve this. Been having a bit of trouble with this. (Image example below)

 

snip.jpg

Highlighted
Community Support Team
Posts: 1,613
Registered: ‎07-30-2018

Re: Help with Bar Chart

hi, @TodGrindley

Based on my research, conditional format color can be achieved but conditional format flip may be not achieved for now.

1. for  conditional format color, you could add a measure like this 

Measure = IF([total]>=2000,1,2)

Then click Format-> data colors-> Advanced colors

4.JPG

5.JPG

2. conditional format flip may be not achieved for now.

If the bar needs to be displayed below X-axis, the values need to be less than zero.

For your requirement, you could post your new idea in Power BI ideas and make this feature coming sooner .

 

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.