Total Stacked column of small multiples

[Fantmas]

Hi All,

I have created a Stacked column chart with small multiples and I would like to have a column which is the total of multiples,

is it possible with PowerBI ?

Thanks for your support,

regards

[v-xiaosun-msft · Accepted solution]

Hi @Fantmas ,

According to your description, here is my solution.

Since you didn’t give the data sample, I built a sample. And I don’t know if it meets your needs.

You can try two ways.

Method 1: Delete “Categories” from Small multiples.

Final output:

Method 2: Create three measures.

Measure =
SUM ( Tabelle1[Rate1] )

Measure2 =
SUM ( Tabelle1[Rate2] )

Measure3 =
SUM ( Tabelle1[Rate3] )

Put them into visual. Final output:

I attach my sample below for your reference.

Best Regards,
Community Support Team _ xiaosun

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

[amitchandak]

@Fantmas , refer if this approach can help, you need to do same for small mutiple column

https://amitchandak.medium.com/power-bi-add-grand-total-row-in-the-bar-visual-44c3d1d463be