How can we improve Power BI?

Totals in stacked column charts

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.

1,016 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Hylke Sasse shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    24 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Tyler Smith commented  ·   ·  Flag as inappropriate

        The ability to show a total on all charts would be lovely. Having to create multiple workaround measures to show a total in the tooltip instead of simply using the legend is a pain in the backside. Definitely long overdue.

      • Joao commented  ·   ·  Flag as inappropriate

        I've faced several times when my boss asked me, ok. I liked TOP N bars, but what is the total?
        So, indeed great idea.

      • TFitz commented  ·   ·  Flag as inappropriate

        Any update on this? I had to layer two charts on top of each other to get the Grand Total to appear above each bar. Every time I need to change or move, it's a hassle. I just had to make an update yesterday and I said to myself "I cannot believe that I have to create this visual in this way" Come on Microsoft. Please implement!

      • Anonymous commented  ·   ·  Flag as inappropriate

        I use a Line and Stacked Column Chart to give me totals for each Bar HOWEVER the other issue I have is that the position for the Data Label total are then completely random. Some within the bar, some above the bar and some, half in and out of the bar and off to one side. Come on MS this is really basic functionality. When Users ask about this and you tell them its not possible to move these it's a little embarrasing.
        Either allow us to reduce the charted area on a bar chart visual so the totals are nicely lined up OR please force the data labels to line up automatically. Thanks.

      • Dicky Lei commented  ·   ·  Flag as inappropriate

        It is a good idea. Currently I have to make a matrix of grand total as a work around

      • TFitz commented  ·   ·  Flag as inappropriate

        Really need this. I layered to column charts on top of each other to make it happen. Not ideal.

      • sakina commented  ·   ·  Flag as inappropriate

        This is a really basic need ! Plus it would be great if we could choose by which value the bars are organised on the chart (by one specific section, or the total amount)

      • Paris Forrer commented  ·   ·  Flag as inappropriate

        I do really think this is a basic and easy feature to implement... cmon Microsoft you can do it!

      • Anonymous commented  ·   ·  Flag as inappropriate

        In the meantime, you can create a measure to sum ALLEXCEPT[your differentiator] and add it as a tooltip to the graph.

      • Anonymous commented  ·   ·  Flag as inappropriate

        Yes that would be very useful, a work around is to have a Line Graph sitting behind, with the Total graphed, with everything except the Data Lables set to White on White - works pretty well.

      • Jake commented  ·   ·  Flag as inappropriate

        Seems like a relatively "quick win" feature to add but would make a huge difference (I'm not a coding expert) Like others I have to add cards above each bar which is a pain.

      • Scott Hietpas commented  ·   ·  Flag as inappropriate

        It would be great if the combined total of the Stacked Column could be used for the "Analyze - Explain the Increase/Decrease" feature. Currently, only differences in individual segments can be analyzed.

      • Alan commented  ·   ·  Flag as inappropriate

        Wow, I was thinking this just the other day.... Yes please

      • Daniel commented  ·   ·  Flag as inappropriate

        We def. need this! I feel like this should be very easy feature add. And great if we didn't have to use a secondary axis as well.

      ← Previous 1

      Feedback and Knowledge Base

      Ready to get started?

      Try new features of Power BI today by signing up and learn more about our powerful suite of apps.