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,224 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

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

25 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Anonymous commented  ·   ·  Flag as inappropriate

    Randomly discovered this hack to show Totals above the columns in stacked column charts.

    Key points:
    1.) Change the Stacked Column Chart to a Combo Chart (Line and stacked column chart).
    2.) In the Combo Chart, drag the same field that you have under "Column values" so that it is duplicated under "Line values".
    3.) Use Formatting -> Shapes -> Stroke Width to make the line thickness=0 and/or remove the line markers.

    Hope this helps.

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

  • Anonymous commented  ·   ·  Flag as inappropriate

    I use a stacked bar with line chart where the line chart provides the grand total

  • 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

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