Ability to add grand total to column/bar charts

[fbcideas_migusr]

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

[maisrando]

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

[paulfinn]

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.

[rogercluff1]

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.

[steve_lamas]

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

[fgutnik1]

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?

[raylenes12]

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

[carolina_navarr]

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...

[rodrigo_figueir]

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

[kyra_meyer]

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

[kevin_farr]

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