line chart in the middle of bar chart - current period versus historical

[vdang]

Hi everyone, 

I am trying to recreate the below chart in power Bi where I would have the line chart lies in the middle of the bar chart. This is case, the line chart would shows monthly average for current year and bar charts shows annual average for the previous years. It's pretty easy to do in excel but I don't quite know how or if it's even possible to do this in Power BI. 

Thanks for your help!

I'm looking to create 

[v-qiuyu-msft]

Hi @vdang,

Power BI doesn't have teh same rendering behavior as in Excel, we can't get the exact same results. But provide the combo charts for us to display data both use line and column charts in one visual. In your scenario, two ways you can try to get the similar results:

#1. You can modeling data to return one column contains the Axis values (2013,2014,2015,Jan,Feb,Mar,......,YTD), and measures return corresponding line and column values. Then use Combo charts to display data in line and column chart.

#2. As the line chart only return monthly average for current year, you can place both Year (2013, 2014,2015,2016) and Month (Jan,Feb,Mar,......) fields in Axis property to enable drill down action. You can drill down from the Year 2016 to its months to see both line and column values. See: Drill down in a visualization in Power BI.

Best Regards,
Qiuyun Yu

[Phil_Seamark]

Hi @vdang

The closest will be the Line/bar chart visuals.  You should be able to get something similar but not exact (with a bit of data modelling).

[vdang]

Thank you Phil! I've played with that a bit but still unsure on how to relate the line graph to be a drilled down to the next level of the bar graph.