Hylke Sasse on 31 Oct 2017 19:06:00
During several presentations I get questions regarding the total of stacked columns. In the current situation you can select to label all the parts of the stacked column but no grand total. I would like to see the option to add a label to the Visuals which shows the total of the stacked column (this counts for values only). Ideally this total would deviate together with the drilldowns you select, so it stays interactive whatever filters you select or subsets you create on your dashboard.
Administrator on 11 Nov 2020 21:33:38
Thanks for all the votes! Happy to report this was shipped in September: https://powerbi.microsoft.com/en-us/blog/power-bi-september-2020-feature-summary/#Total_labels_stacked
- Comments (46)
RE: Totals in stacked column charts
It is a good idea. Currently I have to make a matrix of grand total as a work around
RE: Totals in stacked column charts
Really need this. I layered to column charts on top of each other to make it happen. Not ideal.
RE: Totals in stacked column charts
This is a really basic need ! Plus it would be great if we could choose by which value the bars are organised on the chart (by one specific section, or the total amount)
RE: Totals in stacked column charts
I do really think this is a basic and easy feature to implement... cmon Microsoft you can do it!
RE: Totals in stacked column charts
In the meantime, you can create a measure to sum ALLEXCEPT[your differentiator] and add it as a tooltip to the graph.
RE: Totals in stacked column charts
Yes that would be very useful, a work around is to have a Line Graph sitting behind, with the Total graphed, with everything except the Data Lables set to White on White - works pretty well.
RE: Totals in stacked column charts
Can't believe this is not implemented yet. Such a basic feature with so much value.
RE: Totals in stacked column charts
Also, this idea has been on the go since October 2015!! https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/10214016-display-total-value-of-a-bar-on-a-stacked-bar-char
RE: Totals in stacked column charts
Seems like a relatively "quick win" feature to add but would make a huge difference (I'm not a coding expert) Like others I have to add cards above each bar which is a pain.
RE: Totals in stacked column charts
It would be great if the combined total of the Stacked Column could be used for the "Analyze - Explain the Increase/Decrease" feature. Currently, only differences in individual segments can be analyzed.