Skip to main content

Power BI

Needs Votes

Ability to add grand total to column/bar charts

Vote (483) Share
Meagan's profile image

Meagan on 07 Jan 2016 03:05:57

It would be great to be able to add a grand total column/row to a column/bar chart. For instance, if I have four sales regions and I plot sales by region on a clustered column chart, I would like to be able to add a fifth column that shows the total for all regions. Similar to this functionality in Tableau: http://onlinehelp.tableau.com/current/pro/online/mac/en-us/calculations_totals_grandtotal_turnon.html

Comments (38)
Meagan's profile image Profile Picture

54aa2e60 3521-4f68-970b-1d000954d1fa on 06 Jul 2020 00:18:22

RE: Ability to add grand total to column/bar charts

Any possibility to implement this feature

Meagan's profile image Profile Picture

65c88a40 2a5b-4b65-9906-a3d11145690d on 06 Jul 2020 00:09:37

RE: Ability to add grand total to column/bar charts

Good idea. But in the meantime a Table/Matrix with data bars is perfect for this, and much more space efficient too.

See image here: https://twitter.com/InsightsMachine/status/1236611809760563201

https://twitter.com/InsightsMachine/status/1236611809760563201

Meagan's profile image Profile Picture

16582b1b d072-ea11-a811-000d3a579c38 on 06 Jul 2020 00:07:56

RE: Ability to add grand total to column/bar charts

need this!

Meagan's profile image Profile Picture

0c4d22f4 b81c-4934-a6f4-96f34acda447 on 06 Jul 2020 00:02:22

RE: Ability to add grand total to column/bar charts

Similar suggestion here
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/32082391-totals-in-stacked-column-charts

Meagan's profile image Profile Picture

7d0a70bf 831d-46b3-aca1-1c465cab6252 on 05 Jul 2020 23:55:54

RE: Ability to add grand total to column/bar charts

What's happening, why is this taking so long to add?

Meagan's profile image Profile Picture

69c274fe 2860-4934-9a70-458a8e42004c on 05 Jul 2020 23:54:39

RE: Ability to add grand total to column/bar charts

C'mon man! This ideas been out there since '16? make it happen!

Meagan's profile image Profile Picture

f0d4f6c5 604d-46f9-a478-ccdedb6db908 on 05 Jul 2020 23:52:22

RE: Ability to add grand total to column/bar charts

This would be really useful.

Meagan's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:52:22

RE: Ability to add grand total to column/bar charts

I agree, this would be really useful!

Meagan's profile image Profile Picture

409b1d8f 407f-408f-ba7b-f7811cc3c52f on 05 Jul 2020 23:50:56

RE: Ability to add grand total to column/bar charts

This would be really useful. Currently I need to use an additional KPI on the right of the chart only to show the total value

Meagan's profile image Profile Picture

c131a4bd 941e-4260-99bd-5124456e6988 on 05 Jul 2020 23:49:24

RE: Ability to add grand total to column/bar charts

This would be a great feature as The Business are usually interested in seeing the measures by individual dimensions, while being able to putting them in relation to a grand total column.