Power BI

Needs Votes

Ability to add grand total to column/bar charts

Vote (553)

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)

Comments (39)

Rodrigo Figueiredo on 05 Jul 2020 23:05:36

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

Hi guys, please speed up with this request. It is a regular request for any dashboard I have to implement. Up!

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

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

I tried doing the same as Carolina and it does not work well when the time frame increases. This is a must have.

Carolina on 05 Jul 2020 22:59:04

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

I cannot believe this only has 48 votes!!!
I've worked around this creating an additional chart with the total just right the other. The problem is when you apply filters, the charts change their layout/size and they are not aligned to the total chart, looking awful.
I really cannot believe only 48 votes.. really? and it is definitely not a duplicate of the other 'label' request...

Raylene Ames on 05 Jul 2020 22:47:11

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

Any updates on this functionality being added? I run into this often and don't currently have a workaround.

Felipe Gutnik on 05 Jul 2020 22:38:13

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

Yes, I am also struggling to create the totals in a budget vs. actual bridge chart. Excel does have this functionality but Power BI does not. Anybody can please help with this?

Steve on 05 Jul 2020 22:36:25

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

I wish Power BI could do this as well! The waterfall chart kind of does this, but not exactly...

Roger on 05 Jul 2020 22:30:44

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

I agree with Paul below, the comment that this issue is a duplicate of the other post is inaccurate. The ability to add a total bar to a bar chart is a huge issue that Microsoft also missed in Excel as well. Tableau got it right.

Paul Finn on 05 Jul 2020 22:29:44

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

I don't agree this is a duplicate. The other idea is about labelling the columns/bars in a stacked bar chart. This is about adding an extra bar to show the overall total of other bars/columns on the chart.

Rando Mais on 05 Jul 2020 22:17:49

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

dulpicate of https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/10214016-display-total-value-of-a-bar-on-a-stacked-bar-char