Skip to main content
Microsoft Idea

Power BI

Completed

Display total value of a bar on a stacked bar chart

Vote (494) Share
Jaimie Fox's profile image

Jaimie Fox on 15 Oct 2015 07:07:11

Stacked bar charts already display the value of each section of a bar, but there isn't a way to display the total value of each bar, which would include all the sections.

Administrator on 21 Jul 2021 16:48:37

The Total labels option exists today within the Format settings.

Comments (58)
Jaimie Fox's profile image Profile Picture

Matt Bayne on 05 Jul 2020 22:27:04

RE: Display total value of a bar on a stacked bar chart

This feature is much needed, seems like it would be easy to add.

Jaimie Fox's profile image Profile Picture

Bhanu Jagasia on 05 Jul 2020 22:25:07

RE: Display total value of a bar on a stacked bar chart

How did this get missed for the June update? This would be a simple yet huge addition....

Jaimie Fox's profile image Profile Picture

Power BI User on 05 Jul 2020 22:24:49

RE: Display total value of a bar on a stacked bar chart

I'm suprised this isn't getting more attention. Especially in a sorting situation the chart often becomes less usable due to the inability to sort by the total ammount.

Jaimie Fox's profile image Profile Picture

Jake on 05 Jul 2020 22:18:57

RE: Display total value of a bar on a stacked bar chart

This would be a really useful feature, currently I have to use a line to display the total values which is a work around but not ideal.

Jaimie Fox's profile image Profile Picture

Dan Ahlvin on 05 Jul 2020 22:18:40

RE: Display total value of a bar on a stacked bar chart

There's a workaround for stacked column & line chart: Make the chart show the total value as the line. Then show the line's data labels and make the line transparent. There is no work around for the bar chart. This is a necessary feature.

Jaimie Fox's profile image Profile Picture

Travis Morse on 05 Jul 2020 22:17:17

RE: Display total value of a bar on a stacked bar chart

Definitely needed. The only workaround is to put another chart behind it with just the totals or a stacked bar with line chart which looks ugly with the lines going across the bars.

Jaimie Fox's profile image Profile Picture

John S. on 05 Jul 2020 22:14:56

RE: Display total value of a bar on a stacked bar chart

In line with that suggestion - if we could sort a stacked chart based on the totals rather than one element - that would make it far more useful as well. :)

Jaimie Fox's profile image Profile Picture

Tommy Ballentin on 05 Jul 2020 22:13:08

RE: Display total value of a bar on a stacked bar chart

This would be brilliant. If, in some way, we would be able to display the sales of each brand pr. sales channel, and then display the total sales across brands pr. sales channels, in the same chart.... That would make the whole thing a lot more interesting.