Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric Ideas just got better! New features, better search, and direct team engagement. Learn more

Totals in stacked column charts

During several presentations I get questions regarding the total of stacked columns. In the current situation you can select to label all the parts of the stacked column but no grand total. I would like to see the option to add a label to the Visuals which shows the total of the stacked column (this counts for values only). Ideally this total would deviate together with the drilldowns you select, so it stays interactive whatever filters you select or subsets you create on your dashboard.
Status: Completed
Comments
brian_clarke
New Member
Yes that would be very useful, a work around is to have a Line Graph sitting behind, with the Total graphed, with everything except the Data Lables set to White on White - works pretty well.
andrew_brick2
New Member
In the meantime, you can create a measure to sum ALLEXCEPT[your differentiator] and add it as a tooltip to the graph.
pforrer
New Member
I do really think this is a basic and easy feature to implement... cmon Microsoft you can do it!
sakina_mohammad
New Member
This is a really basic need ! Plus it would be great if we could choose by which value the bars are organised on the chart (by one specific section, or the total amount)
Teresa_Fitzpatr
New Member
Really need this. I layered to column charts on top of each other to make it happen. Not ideal.
dicky_lei
New Member
It is a good idea. Currently I have to make a matrix of grand total as a work around
rhmeing
New Member
Would also need the ability to sort by the total.
sddally
New Member
I use a stacked bar with line chart where the line chart provides the grand total
p_lamonica
New Member
I use a Line and Stacked Column Chart to give me totals for each Bar HOWEVER the other issue I have is that the position for the Data Label total are then completely random. Some within the bar, some above the bar and some, half in and out of the bar and off to one side. Come on MS this is really basic functionality. When Users ask about this and you tell them its not possible to move these it's a little embarrasing. Either allow us to reduce the charted area on a bar chart visual so the totals are nicely lined up OR please force the data labels to line up automatically. Thanks.
Teresa_Fitzpatr
New Member
Any update on this? I had to layer two charts on top of each other to get the Grand Total to appear above each bar. Every time I need to change or move, it's a hassle. I just had to make an update yesterday and I said to myself "I cannot believe that I have to create this visual in this way" Come on Microsoft. Please implement!
OSZAR »