Stack Column Chart total at the top

[Anonymous]

Hi Gurus, 

Is there anyway I can total up Stack Bar chart total while still using the legend.

In the Below graph for December I need 75 as total at the top instead of indivisual categories. 

would be a handy Options in the graph if it is not availbe.

[amitchandak]

@Anonymous , see this can help

https://radacad.com/showing-the-total-value-in-stacked-column-chart-in-power-bi

[parry2k]

@Anonymous you can create a measure to give the total and then use combo chart and put this measure on a line chart and make line style/stroke to 0, so that you actually don't see a line but only see data labels for the line which in theory will be total of bar chart.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[parry2k · Accepted solution]

@Anonymous hee is an example.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[Anonymous]

@parry2k , 

what if I want the same to a Stacked Bar Chart. is there an option avilable.

[parry2k]

@Anonymous yes sir, and set stroke width to 0 to hide the actual line.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[Anonymous]

@parry2k , 

when you say combo chart did you mean stack bar and line chart ?