Forum Discussion

fishbone77's avatar
fishbone77
Frequent Visitor
3 years ago
Solved

Need help with Partially Stacked Bar Chart

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

Need Help
  • Ritaf1983's avatar
    Ritaf1983
    3 years ago

    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

2 Replies

  • Ritaf1983's avatar
    Ritaf1983
    Super User
    3 years ago

    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's avatar
      fishbone77
      Frequent Visitor
      3 years ago

      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!