Skip to main content
Microsoft Idea

Power BI

Needs Votes

Ability to add grand total to column/bar charts

Vote (552) 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 (39)
Meagan's profile image Profile Picture

Power BI User on 05 Jul 2020 23:25:20

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

All sales operations need this!

Meagan's profile image Profile Picture

Power BI User on 05 Jul 2020 23:22:37

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

Insane this isn't already available.

Meagan's profile image Profile Picture

Vaidøtas Ivøška on 05 Jul 2020 23:22:24

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

are you freakin' kidding me this is not on it yet?

Meagan's profile image Profile Picture

Christopher Eby on 05 Jul 2020 23:21:55

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

please consider adding this - pretty basic stuff!

Meagan's profile image Profile Picture

Jacques Swart on 05 Jul 2020 23:19:04

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

Please add this feature. Current workaround is creating a hierarchy, but it does not look as nice.

Meagan's profile image Profile Picture

Mike Honey on 05 Jul 2020 23:16:37

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

A common requirement. Easy to do in Excel, Tableau, SSRS, many other tools.

Clearly not a duplicate.

Meagan's profile image Profile Picture

Roger Watson on 05 Jul 2020 23:11:03

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

This is basic requirement, whilst there are workarounds they are messy and this should be standard functionality that can be switched on and off - this is one a number of things that Tableau can do but Power BI can't and is leading to some people in my business who have been users or consumers of Tableau reports questioning whether Power BI is the right tool for the business.

Meagan's profile image Profile Picture

Jeegna on 05 Jul 2020 23:10:41

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

This is a basic request from most users - please add this one soon!

Meagan's profile image Profile Picture

Daniel on 05 Jul 2020 23:06:40

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

Agreed. This is a basic feature of most other viz software. Please add soon!

Meagan's profile image Profile Picture

Power BI User on 05 Jul 2020 23:05:54

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

Agreed. This would be a great addition to these charts.