Power BI Clustered and Stacked Column Chart

2:52 to get right into it!
This video is a quick tutorial on how to simulate a clustered and stacked chart in Power BI. This method required a manual table entry to indicate the order of the items in the axis. If you prefer to have everything as a calculation to keep the dashboard sustainable with updated datasets, please see my SkillShare class for a walk through.

[catarts]

Its so strange that there are charts that excel can do that Power BI can't. Thanks for the video. It gave me the very lazy idea to export the chart then chuck it into excel and create a powerpivot chart which groups things automatically.

[takamano]

Very good instructions this is! I hope Microsoft adds this graph as default visual.

[diptisharma]

Thanks for the video, it was really helps me a lot.
Thanks again!!

[PinoAino]

Congratulations, you are a genius!

An incredibly effective solution, Microsoft should reward you!

Instead, I was delusional that I solved it by overlapping 2 lined and stacked column charts so that they looked clustered. I was thinking of solving the problem of proportionality on the Y axis by means of a transparent line drawn on the maximum.
Unfortunately, the rendering between the PowerBI Desktop application and the WEB service are different so the proportions on the Y axis are out of phase.

THANK YOU for your solution :-)

[inderveers]

can we use this approach if we have to compare the results for different years ? first bar is for current year and second bar for different year ?

[Riftzed]

Finally i found something brilliant ! Thank you

I need to compare the previsional workload with the realized workload by day and article
So i have my 2 calculated columns "previsional workload" and "realized workload" and the columns "article" "day" are in text

How could i adapt your method to my case please ?

[robertarchibald]

This is half the way there, but no use if the chart is dynamic and/or connected to changeable data (and I'm not sure why you'd use PBI if it's not). For the blank rows you can just put a space, and add a sort by column in the query editor (adjust dax or in query editor to only show blank rows where the there is data in the real rows, and also not after the final row) - no need to export to excel, no need to use static shapes to cover anything, and no need to manually filter out any values.

[Andy]

There appears to be a new visualization called 'Clustered Stacked bar chart' that does this.

[patricklynch]

Is it possible to then add a line chart to this stacked and clustered?

[TheMacmatthew]

This is really amazing! Would you mind sharing how you did the product name title in the center underneath the two country names you have? For example, on your initial report, "Paseo", "VIT", "Velo" etc. are all in the center underneath the charts... did you do that manually or is there a way to do that automatically in Power BI?

[Groundual]

Why is this in the 442oons factor playlist