Create stacked column chart with Grandtotals and double split.

[stanislav_dugas]

Hi Everyone,

I am thinking about creating a visual like this for my Power BI Dashboard. But all i could find is just partial solutions.

Either i can create a UK EMEA and UK Global split but I cant split it across periods without using drilldown and also I dont see a grandtotal columns.

Or i can create Grandtotal for whole UK and split it across periods but then i odont see the individual regions (UK EMEA and UK Globals).

This is what i would like to create

Is there any way to do. Is there any custom visual that allows to create a view like this?

Thanks alot for any help.

[amitchandak]

@stanislav_dugas , do you grand total like in each smart visual

That feature was given for stacked in Sep 2020 -https://powerbi.microsoft.com/en-us/blog/power-bi-september-2020-feature-summary/#Total_labels_stack...

Or are looking for one without split of small multiple or legend. In both case you need to have one additional visual

[stanislav_dugas]

@amitchandak 

Based on your instructions i was able to figure out most of the visual. 

Maybe just one thing do you know if its possible to add change % that i have in the expected visual?

To show the percentual change between two period for each group.

So % change for UK between P9 and FA then % change for UK Globals between P9 and FA and same for UK Total.

[amitchandak · Accepted solution]

@stanislav_dugas , Not very clear, but do you have to check if small multiples of Dec2020 can help you?

https://www.youtube.com/watch?v=a7PIApvjmVw

https://powerbi.microsoft.com/en-us/blog/power-bi-december-2020-feature-summary/#_Toc58831297

[stanislav_dugas]

@amitchandak 

This helped alot... now i need to create a Grandtotal from that. Do you know how that could be accomplished?

This is what i get by applying small multiples.

Also adding my selections/filters.