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.

775 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 →

    16 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • 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

      • Anonymous 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.

      • 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.

      • Anonymous commented  ·   ·  Flag as inappropriate

        This is great. I have been asked all the time to manually add the total in the stack bar charts.

      • Briton Wells commented  ·   ·  Flag as inappropriate

        This would also solve a similar issue I am having with data labels on dates where the total is 0 - each category is too small to contain the label, so no label is shown (in this case the total would still show 0)

      • Harsha commented  ·   ·  Flag as inappropriate

        must needed..alternatively I am having a card for each legend and placed on top of each bars, which is not at all preferable but serves my need for now

      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.