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

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

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?

example.png

 

3 REPLIES 3
BhaveshPatel
Community Champion
Community Champion

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

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

Hi Bhavesh,

 

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

 Stack1Stack2Stack3Line1LineWithMarker1
Apr199922839197%139
May199927020495%118
Jun205924520997%147
Jul187208124796%92

 

Regards,

Antony

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.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Kudoed Authors