1654
H

Totals in stacked column charts

Hylke Sasse on 10/31/2017 7:06:00 PM
1654
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.
STATUS DETAILS
Completed
Ideas Administrator

Administrator on 11/11/2020 9:33:38 PM

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

H

H

RE: Totals in stacked column charts

Inge Nordén on 7/21/2020 4:30:23 PM

Any update on this?

H

H

RE: Totals in stacked column charts

Aivis Pavlovs on 7/17/2020 8:28:59 AM

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

H

H

RE: Totals in stacked column charts

Nick on 7/6/2020 12:17:10 AM

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

H

H

RE: Totals in stacked column charts

Lincoln Santiago on 7/6/2020 12:14:24 AM

Extremely important and useful facture for the business area.

H

H

RE: Totals in stacked column charts

Christian on 7/6/2020 12:11:45 AM

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.

H

H

RE: Totals in stacked column charts

Andrew Lucius on 7/6/2020 12:09:44 AM

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

H

H

RE: Totals in stacked column charts

Kyle Cheney on 7/6/2020 12:08:21 AM

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

H

H

RE: Totals in stacked column charts

Power BI User on 7/6/2020 12:08:18 AM

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

H

H

RE: Totals in stacked column charts

Kjersti on 7/6/2020 12:07:19 AM

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

H

H

RE: Totals in stacked column charts

Power BI User on 7/6/2020 12:07:13 AM

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