Skip to main content
Microsoft Idea

    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

    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?

    Hylke Sasse's profile image Profile Picture

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

    RE: Totals in stacked column charts

    Any update on this?

    Hylke Sasse's profile image Profile Picture

    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

    Hylke Sasse's profile image Profile Picture

    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?

    Hylke Sasse's profile image Profile Picture

    Lincoln Santiago on 06 Jul 2020 00:14:24

    RE: Totals in stacked column charts

    Extremely important and useful facture for the business area.

    Hylke Sasse's profile image Profile Picture

    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.

    Hylke Sasse's profile image Profile Picture

    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.

    Hylke Sasse's profile image Profile Picture

    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?

    Hylke Sasse's profile image Profile Picture

    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

    Hylke Sasse's profile image Profile Picture

    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?