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
Wow, there are ideas related to this since 2015... around 2,200 votes combining all of them and still under review. Please add it to the backlog already! I am tired of hacking my way around to get such a simple feature
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/11330133-ability-to-add-grand-total-to-column-bar-charts
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
any updates? Infuriating not to be able to do this seemingly simple thing.
RE: Totals in stacked column charts
I agree.
RE: Totals in stacked column charts
Similar discussion here
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/11330133-ability-to-add-grand-total-to-column-bar-charts
and here
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 such a simple quick win
RE: Totals in stacked column charts
'+1 for a basic, included feature in Excel that a "world class" BI tool should have built in
RE: Totals in stacked column charts
Come on PBI team! This is such a basic need. I was just trying to edit some of my hacked charts where I had to layer one chart on top of another to get the grand total. I'm surprised with all your releases this hasn't been include. I'm begging you, please implement!
RE: Totals in stacked column charts
This is incredible, we are still waiting a simple way to do this, may be you can add in the "Analytics Pane" the line "Total" just a suggest =/ thanks
RE: Totals in stacked column charts
It's egregious that this option still does not exist when every other BI tool makes it simple. Using the line work-around does not work as I need to use line to show a % figure
RE: Totals in stacked column charts
This idea is almost two years old, can we please do something about this? The obvious work around is a beating, and you're kind of out of luck if certain components of the stacked column are negative.