Skip to main content

Power BI

Needs Votes

Ability to add grand total to column/bar charts

Vote (553) 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

Omar Al Zeidi on 09 Feb 2021 04:14:52

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

Chiming with the rest of the community here. a very necessary feature that is still missing in PowerBI.

Meagan's profile image Profile Picture

Power BI User 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

jeffrey Weir 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

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

Laurits Bertelsen 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

Power BI User 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

Mad Max 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

Laura Herrmann 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

Power BI Ideas Admin 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

Power BI User 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