Jaws Bar Chart (Dua Axis in Bottom and Up)

[alishanf]

Hi All, I wonder if anyone have ever built similar chart as this one above. It commonly called "JAWS" chart

I think it requires dual axis in the bottom and upper section. It is not a stacked bar char, and the number given is not a percentage but real value.

The graph above was made in Excel (reference: https://alesandrab.wordpress.com/2013/06/21/how-to-create-a-jaws-chart/)

Thanks and appreciate your help!!

[alishanf]

Hello,

Yes, I suppose Power BI doesn't have a direct option to do this and this is the closest solution we can do to achieve this visual. 

Thank you for your suggestion!

[v-rzhou-msft · Accepted solution]

Hi @alishanf ,

Do you want to create a visual as below in Power BI?

As far as I know, currently Power BI doesn't support us to create a visual like this directly. We can combine two clustered column chart to achieve this goal.

Blue one is normal column chart, we need to set the turn off the Y axis title and value, turn on data label and set it inside end.

Red one, we need to turn off the background, set it invert range and then do same thing as above chart.

       

We need to set Y axis range for both visuals as the same. Here I set them from auto to 110.

Then combine them as one visual. Result is as below.

Best Regards,
Rico Zhou

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