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

Clustered Stacked Combo Column Chart

Dear All,

 

Is there anyway we can get a Power BI chart or PB Custom Visualization as below. I built it in Excel.  

 

2020-02-20 Clustered Stacked Combo Column Chart.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User II
Super User II

Re: Clustered Stacked Combo Column Chart

Hi @Sukhomoyb,

If you wish to request this for inclusion in Power BI's core visual functionality, there is an idea you can vote on here.

This particular visual could be built using the custom visuals SDK or Charticulator, which offers the option to export your work as a custom visual that you can load into a Power BI report.

If you're looking for someone to develop the visual for you, there are a number of consulting services on AppSource that you may be able to engage with.

Hopefully this gives you some ideas on how you might be able to proceed.

Regards,

Daniel

 

EDIT: I had a look in the Marketplace and this is the closest I can get to your design (I've added a matrix showing the mocked-up data; I haven't done the measures for %):

image.png

The visual is Stacked Column Chart by Akvelon, which has a small multiple capability and can give the impression of having a secondary x-axis. I understand that this is not perfect but may give you another avenue to explore. I've attached the workbook below also in case you want to have a quick look without the setup, or see if you can improve my attempt (which is more than likely possible).





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

Proud to be a Super User!




View solution in original post

3 REPLIES 3
Highlighted
Super User II
Super User II

Re: Clustered Stacked Combo Column Chart

Hi @Sukhomoyb,

If you wish to request this for inclusion in Power BI's core visual functionality, there is an idea you can vote on here.

This particular visual could be built using the custom visuals SDK or Charticulator, which offers the option to export your work as a custom visual that you can load into a Power BI report.

If you're looking for someone to develop the visual for you, there are a number of consulting services on AppSource that you may be able to engage with.

Hopefully this gives you some ideas on how you might be able to proceed.

Regards,

Daniel

 

EDIT: I had a look in the Marketplace and this is the closest I can get to your design (I've added a matrix showing the mocked-up data; I haven't done the measures for %):

image.png

The visual is Stacked Column Chart by Akvelon, which has a small multiple capability and can give the impression of having a secondary x-axis. I understand that this is not perfect but may give you another avenue to explore. I've attached the workbook below also in case you want to have a quick look without the setup, or see if you can improve my attempt (which is more than likely possible).





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

Proud to be a Super User!




View solution in original post

Highlighted

Re: Clustered Stacked Combo Column Chart

HI @dm-p,

Thanks for great advice, I´m also looking for a clustered and stacked column chart. Is there any way to remove the multiple Y-axes? So I only have one Y-axis to the far left?

 

Thanks,

Helena

Highlighted
Super User II
Super User II

Re: Clustered Stacked Combo Column Chart

Hi @helenawickstrom,

I've reviewed the settings in that visual and it looks like there's no such option. I'd suggest following up with the vendor if you'd like to request such a feature.

Regards,

Daniel





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

Proud to be a Super User!




Helpful resources

Announcements
Meet the 2020 Season 2 Power BI Super Users!

Meet the 2020 Season 2 Power BI Super Users!

Find out who's part of the program this season, and welcome the new Super Users.

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Featured Data Story of The Month

Featured Data Story of The Month

All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.

Power BI Dev Camp - Developing with .NET Core

Power BI Dev Camp - Developing with .NET Core

Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.

Top Solution Authors