Skip to main content

Power BI

Needs Votes

Display total value of a bar on a stacked bar chart

Vote (473) 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.

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

7803b209 4f55-40f6-94d6-35cc0df1ae11 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

c2ed550e 7154-4212-95a9-98090535a9fa 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

52b5cce4 5162-45fc-a468-4609777326e8 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

f7d44449 9563-4e41-876e-a71230ff0423 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

4a1f979a 961d-41d1-937d-b12938427c17 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

e8aa1f63 7f13-46cc-ab12-d6c41da68bc0 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

0743e767 97dd-4a3f-b45a-ed3e054ab5b8 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.