How to create a combo of 100% stacked column chart and line chart?

[AntonyPallups]

In Excel, we have the option to create combo charts of different types. Do we have the same kind of option in PowerBI? I am trying to re-create the below chart in PowerBI. As you can see, it is a combo of 100% Stacked Column, Line Chart and Line Chart with markers. How can this be accomplished?

[BhaveshPatel]

Yes, You can achieve this and more than this in PowerBI. Please post your sample data and will recreate a solution for you.

[AntonyPallups]

Hi Bhavesh,

A sample data would be like below. And thanks a lot for helping out! 🙂

	Stack1	Stack2	Stack3	Line1	LineWithMarker1
Apr	19992	283	91	97%	139
May	19992	70	204	95%	118
Jun	20592	45	209	97%	147
Jul	18720	812	47	96%	92

Regards,

Antony

[KHorseman]

I don't think you can do this without either creating a custom visual or maybe using R script to generate the chart. The only combo charts are stacked with line and clustered with line, not 100% stacked with line.