Help with Bar Chart

[TodGrindley]

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)

[v-lili6-msft]

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

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