Show Totals & Average line in Stacked Column Chart

[Anonymous]

Hi,

How to show Totals&Average line in Stacked Column Chart?

I tried the work around to show totals in stacked column chart. but I need to show Average line as well.

When we show totals on top we set Stoke width under shapes to 0. Due to that I won't be able to show the average line,

Can anyone help me in getting the Totals&Average line using Stacked column chart in power bi?

A Quick help would be much appreciated

[v-lili6-msft]

hi  @Anonymous 

You could use combo chart to get it, just create two measure: Totals & Average, then drag them into Line Values of the Line and stacked column chart.

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-combo-chart

Regards,

Lin

[Anonymous]

Hi @v-lili6-msft ,

Thank you. It worked to some extent.

But Avg. is repeating for each data point on the axis. For example, Avg values is 30M which is repeating for each data point in the axis starting from Jan to Dec.

Is there a way to limit the avg value label to one time instead of each dtaa point?

reg Totals on Stacked column chart, I am not getting totals on top for data points where there is a negative axis. How can we achiove this to get totals on top even if we hvae negative values on data points.

A Quick help would be much appreciated