Forum Discussion
Adding average to stacked bar chart
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
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.
5 Replies
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://blog.enterprisedna.co/showcasing-trends-using-moving-average-techniques-in-power-bi/
Anonymous
Have you checked whether you can add the measure on a dual y-axis chart?
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.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
