cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Display total on top of stacked chart

I have a stacked chart and I would like to have display the total for each column. If I in format pane switches "Data Labels" on I get the data label pr part of the stacked column instead of the total for the column.

 

Can I somehow get the total?

 

Also can I change the way the data labels are displayed - it is displayed in thousands, but my figures are already in thousands. So I get thousands of thousands?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Power BI Team
Power BI Team

Re: Display total on top of stacked chart

Hi Morten. We don't have that functionality out-of-the-box yet, but you could try creating the same chart but not with the series, turn on data labels and then place it exactly behind the first one. You'll find X/Y/Width/Height settings boxes in the formatting pane to help position it. Bit of a workaround but might get what you want! You'll also find settings to control the Display Units in the formatting pane too. Hope that helps! Will

View solution in original post

24 REPLIES 24
Highlighted
Power BI Team
Power BI Team

Re: Display total on top of stacked chart

Hi Morten. We don't have that functionality out-of-the-box yet, but you could try creating the same chart but not with the series, turn on data labels and then place it exactly behind the first one. You'll find X/Y/Width/Height settings boxes in the formatting pane to help position it. Bit of a workaround but might get what you want! You'll also find settings to control the Display Units in the formatting pane too. Hope that helps! Will

View solution in original post

Highlighted
Frequent Visitor

Re: Display total on top of stacked chart

Hi Will.

 

Thanks for your reply - I will try and make it work 🙂

 

Best regards

Morten

Highlighted
Advocate II
Advocate II

Re: Display total on top of stacked chart

I came accross the same issue,

 

I've made a work around by simply using 'Line and Stacked Column Chart', setting the line value as the total quantity, same result, just have lines running through your graph. Could always change the colour of line to something subtle? 

 

Capture.PNG

Highlighted
New Member

Re: Display total on top of stacked chart

Elliott, I have tried you solution but labels are not displayed for the "top" series (purple in your case). For the "bottom" series and the line chart they are displayed correctly. It seems I cannot use the same variable for both "Column values" and "Line values". I am using, for example, Sales for both of them. How can I solve this?

Highlighted
New Member

Re: Display total on top of stacked chart

Hi.

 

Let me explain better...

 

I have financial data received in different banks. I would like to display Date on X-Axis and Net Income on Y-Axis (divided into the two possible banks). I am using the following configuration for "Line and stacked column chart":

  • Shared axis: Date
  • Column series: Bank
  • Column values: Net Income
  • Line values: Net Income

If I let "Line values" empty, labels are OK, but the Total of two columns are not displayed.

When I include "Line values" equals to "Column values", Total is displayed, but labels for top column is empty.

 

Highlighted
Advocate II
Advocate II

Re: Display total on top of stacked chart

Hi Glaubeferreria,

 

Sorry for the late response, have just logged back in after a while out.

 

I believe I understand what you are trying to explain,

I have just setup a quick template with the similar kind of layout that you are describing.

 

I believe that this issue could well be with the physical formatting of the graph rather than a data issue.

 

Capture.PNGCapture2.PNG

 

I believe that the reason you may not be able to see total could be due to the size of your graphs?


If you see the 2 above screenshots I have taken, I have simply only resized the graphs and as you can see I have lost most of my data labels for my "Green" area.

 

Unfortunately, I do not believe there is any way around this due to the size formatting of the graph. I would recommend playing around with the size of the graph to see if it makes any difference, you can also try and change the label size but there is a minimum limit of 8pt.

Highlighted
Regular Visitor

Re: Display total on top of stacked chart

Hi Morten,

 

I recently run through the same obstacle. I solved it using a Card (Visualizations) with the same values and filters as the stached chart and than placing the card just above the desiderd chart column. It works perfectly! 

 

Whatever other filter you will apply to that report page it will be applied automatically at the stached chart and to the Card.

 

I hope it was useful!

Rocco.

 

 

 

 

Highlighted
Regular Visitor

Re: Display total on top of stacked chart

Hi Morten,

 

I recently run through the same obstacle. I solved it using a Card (Visualizations) with the same values and filters as the stached chart and than placing the card just above the desiderd chart column. It works perfectly! 

 

Whatever other filter you will apply to that report page it will be applied automatically at the stached chart and to the Card.

 

I hope it was useful!

Rocco.

 

 

 

 

Highlighted
Regular Visitor

Re: Display total on top of stacked chart

Hello, 

 

I was wondering if there were any way to only display the line graph data points. My data becomes too cluttered if I have both data points on it.

 

Thank you,

Anais 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors