How to create stacked Column Chart with the Total divided for each group

[marcocapo]

Hi All,

I'm trying to create a Stacked Column Chart where I have the X quantity that is the total and then I have Y, Z, and W quantities that are other column of my table, but that are subsets of my X!

So, in my tables I have these four columns that representing 4 quantities, where one is the total and the other 3 are the subclasses! Is it possible to create a stacked column chart like that?

Thanks for your help,

Marco

[v-angzheng-msft · Accepted solution]

Hi, @marcocapo 

This is what a stacked Column chart do.

Best Regards,
Community Support Team _ Zeon Zheng

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

[radhey_rec]

Hi @marcocapo ,

Your query is not very clear at least to me. 

What I could not understand was if X = Y+Z+W, what stops you using only Y, Z and W columns ignoring X altogether?

 Can you also put what you are getting by default in Power BI?

Thanks,

Radhey

[amitchandak]

@marcocapo , In stacked visual you can use multiple measures , if you are not using legend 

[marcocapo]

Yes, but the stacked visual sums all the measures that I put in. I need that the X measures contains the other 3