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

Alan on 05 Jul 2020 23:07:22

RE: Totals in stacked column charts

Wow, I was thinking this just the other day.... Yes please

Hylke Sasse's profile image Profile Picture

Daniel on 05 Jul 2020 23:06:46

RE: Totals in stacked column charts

We def. need this! I feel like this should be very easy feature add. And great if we didn't have to use a secondary axis as well.

Hylke Sasse's profile image Profile Picture

Power BI User on 05 Jul 2020 23:05:54

RE: Totals in stacked column charts

This is great. I have been asked all the time to manually add the total in the stack bar charts.

Hylke Sasse's profile image Profile Picture

Briton Wells on 05 Jul 2020 23:04:35

RE: Totals in stacked column charts

This would also solve a similar issue I am having with data labels on dates where the total is 0 - each category is too small to contain the label, so no label is shown (in this case the total would still show 0)

Hylke Sasse's profile image Profile Picture

Power BI User on 05 Jul 2020 23:03:51

RE: Totals in stacked column charts

This is a great idea!

Hylke Sasse's profile image Profile Picture

Harsha on 05 Jul 2020 23:03:15

RE: Totals in stacked column charts

must needed..alternatively I am having a card for each legend and placed on top of each bars, which is not at all preferable but serves my need for now