Adding average to stacked bar chart

[Anonymous]

Hello everyone!

Is there any way to add average line to stacked bar chart?

I need my average line to change depending on what filter via slicer I choose

I do not see any way of adding it here, but I hope for your help

Best regards,

Temirlan

[paulasanta]

Did you make it work? I also need to add an average line on my stacked graph and change it upon time period. Thanks,

Paula

[Anonymous · Accepted solution]

@Anonymous 

You cannot add average line to a separate stacked bar chart. You should use the clustered bar chart, the displayed visual should be the same but you can use more analytic features.

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[themistoklis]

@Anonymous 

I suggest you create a measure first and then add it to the graph and see if it helps.

Maybe the links below will help:

https://community.powerbi.com/t5/Desktop/How-to-calculate-an-average-line-in-the-Line-Chart/td-p/232371

https://blog.enterprisedna.co/showcasing-trends-using-moving-average-techniques-in-power-bi/

[Anonymous]

Unfortunately, it doesn't help, I can either have my data or measure on the graph

[themistoklis]

@Anonymous 

Have you checked whether you can add the measure on a dual y-axis chart?