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

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

Any update on this?

H

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

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

H

Extremely important and useful facture for the business area.

H

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

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

H

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

H

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

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

H

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