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.
- Comments (45)
RE: Totals in stacked column charts
Any update on this?
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
RE: Totals in stacked column charts
This just seems like such an obvious feature. What good is the stacked bar chart without a total?
RE: Totals in stacked column charts
Extremely important and useful facture for the business area.
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.
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.
RE: Totals in stacked column charts
Any update on this? Or being able to show percent and count in non-stacked bar charts?
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
RE: Totals in stacked column charts
Can when all get an ETA as to when this will be available?
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