Power BI

Completed

Totals in stacked column charts

Vote (1654)

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)

Comments (46)

Nicholas Ehrlich on 24 May 2022 22:26:46

RE: Totals in stacked column charts

Sadly, this doesn't work if you want to show "Small Multiples." I'd consider that a bug, not a new feature. Any chance that could get fixed?

Inge Nordén on 21 Jul 2020 16:30:23

RE: Totals in stacked column charts

Any update on this?

Aivis Pavlovs on 17 Jul 2020 08:28:59

RE: Totals in stacked column charts

This can already be done by custom visuals like Drill Down Combo PRO, where you can have not only total stack values but also subtotals.

sample 1 = Total for stacked columns on chart and series specific values in tooltip

https://ibb.co/NWY1Nf1

sample 2 = Total and Subtotal values on chart and series specific values in tooltip

https://ibb.co/ZxP2bJ9

Nick on 06 Jul 2020 00:17:10

RE: Totals in stacked column charts

This just seems like such an obvious feature. What good is the stacked bar chart without a total?

Lincoln Santiago on 06 Jul 2020 00:14:24

RE: Totals in stacked column charts

Extremely important and useful facture for the business area.

Christian on 06 Jul 2020 00:11:45

RE: Totals in stacked column charts

BUMP! This is a complete must . The weird thing is that you can do this in a Matrix visual but not in a 100% stacked bar chart. They have the same data if you select "Row subtotal" so there are no real constraint to this.

Andrew Lucius on 06 Jul 2020 00:09:44

RE: Totals in stacked column charts

Any update on this? I use the multi-row card as a work-around, but it's a pain.

Kyle Cheney on 06 Jul 2020 00:08:21

RE: Totals in stacked column charts

Any update on this? Or being able to show percent and count in non-stacked bar charts?

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

RE: Totals in stacked column charts

xViz Multiple Axes does it, give it a try https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA200000183?src=office&tab=Overview

https://twitter.com/nsdevaraj/status/1229376670391398400

Kjersti on 06 Jul 2020 00:07:19

RE: Totals in stacked column charts

Can when all get an ETA as to when this will be available?