cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sukhomoyb
Helper I
Helper I

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
dm-p
Super User
Super User

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!


My course: Introduction to Developing Power BI Visuals


On how to ask a technical question, if you really want an answer (courtesy of SQLBI)




View solution in original post

3 REPLIES 3
dm-p
Super User
Super User

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!


My course: Introduction to Developing Power BI Visuals


On how to ask a technical question, if you really want an answer (courtesy of SQLBI)




View solution in original post

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

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!


My course: Introduction to Developing Power BI Visuals


On how to ask a technical question, if you really want an answer (courtesy of SQLBI)




Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors