topic Re: Clustered Stacked Combo Column Chart in Custom Visuals Development Discussion

Clustered Stacked Combo Column Chart

Anonymous — Thu, 20 Feb 2020 09:43:14 GMT

Dear All,

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

Re: Clustered Stacked Combo Column Chart

dm-p — Thu, 20 Feb 2020 23:57:57 GMT

Hi @Anonymous,

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 %):

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).

Re: Clustered Stacked Combo Column Chart

Anonymous — Sat, 11 Apr 2020 09:53:33 GMT

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

Re: Clustered Stacked Combo Column Chart

dm-p — Sat, 11 Apr 2020 22:56:37 GMT

Hi @Anonymous,

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