Need help with Partially Stacked Bar Chart

[fishbone77]

Hi Everybody

I have 6 different measures i want to show in a "partially" stacked bar chart. if i put them all in a normal bar chart, i end up with only one bar: 

however, in the end i want 3 different bars where some of the measures are stacked. For example:

Bar 1: Measure 1 + Measure 2

Bar 2: Measure 3 + Measure 4 + Measure 5

Bar 3: Measure 6

How can I achieve this? I tried something with a disconnected table, but it didn't work out either. 

Any help is greatly appreciated!

Thanks

[Ritaf1983 · Accepted solution]

Hi @fishbone77 
There is no option to achieve it in one chart.
Only to create 3 different.
You can try to make the same proportions, switch off axes, and titles, modify 0 paddings, and group between them, not sure it will look good.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[fishbone77]

Thanks for your reply. i'll try it out & see if it looks alright. there is a custom visual that does exactly what i need, but i was hoping to do it manually so i can avoid licencing the visual. 

thanks!