Forum Discussion
Helper IIICreate stacked column chart with Grandtotals and double split.
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.
@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
4 Replies
- amitchandak
Super User
@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_dugasThis 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.
- 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_stacked
Or are looking for one without split of small multiple or legend. In both case you need to have one additional visual
- stanislav_dugas
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.