How to show only sum of data in Stacked chart legend

[Anonymous]

Hi all,

I have a table like that .

I want to show only sum of legend at the end of chart. As in the example below

Is it possible to do this ? I'll be happy if anyone can help me

[Arentir]

HI @Anonymous 

That is the closest I could get to your query

I used "Line and Stacked Column Chart" object. The column value is a regular sum. The line value is a sum ignoring the legend field. In here it is "Product" so the measure would be: SUM All Product = CALCULATE(SUM(Table1[Amount]),ALL(Table1[Product]) )

I have formated the line so it disappears: In Shape, have Stroke width = 0

I also changed the formatting of the data label so your total stands out.

It would be a good idea to open/vote an improvement to PBI Desktop . You can normally remove data label for either the line or column (perfect in your case), but the legend on the column prevent that!

My pbix file here

https://1drv.ms/u/s!As5oZCclkGkWgSZRM1Lujl5Psioa

Hope it helps though!

[Anonymous · Accepted solution]

Thank you for your valuable support.

The idea you found was quite logical and I made some changes on your line and stacked column chart.

I created a duplicated of the chart. I unselected the Sum amount from new chart. Then it shows only sum of legends.

It looks like that.

Finally i superimposed two chart and hide legend, x-axis, y-axis and title from duplicated chart. Thats final state.

It's not a actual solution but for today it was fine for me 🙂