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

Help with Bar Chart

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

1 REPLY 1
Community Support Team
Community Support Team

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.