Skip to main content

Power BI

Completed

Totals in stacked column charts

Vote (1654) Share
Hylke Sasse's profile image

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)
Hylke Sasse's profile image Profile Picture

Power BI User on 06 Jul 2020 00:07:13

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

Hylke Sasse's profile image Profile Picture

Power BI User on 06 Jul 2020 00:04:31

RE: Totals in stacked column charts

any updates? Infuriating not to be able to do this seemingly simple thing.

Hylke Sasse's profile image Profile Picture

Dan J on 06 Jul 2020 00:04:18

RE: Totals in stacked column charts

I agree.

Hylke Sasse's profile image Profile Picture

Laurits Bertelsen on 06 Jul 2020 00:02:22

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

Hylke Sasse's profile image Profile Picture

Power BI User on 06 Jul 2020 00:02:18

RE: Totals in stacked column charts

Seems like such a simple quick win

Hylke Sasse's profile image Profile Picture

Power BI User on 06 Jul 2020 00:02:10

RE: Totals in stacked column charts

'+1 for a basic, included feature in Excel that a "world class" BI tool should have built in

Hylke Sasse's profile image Profile Picture

Teresa Fitzpatrick on 06 Jul 2020 00:01:11

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!

Hylke Sasse's profile image Profile Picture

Heriberto Carrizales on 06 Jul 2020 00:00:57

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

Hylke Sasse's profile image Profile Picture

Power BI User on 05 Jul 2020 23:59:39

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

Hylke Sasse's profile image Profile Picture

Alex Garrison on 05 Jul 2020 23:59:08

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.