How to add a average line across the Bar chart to return average ?

[admin11]

Hi All

I have a bar chart , in the past i have add a red line , which is return average of the bar. i forget how to add the line , hope some one can share with me.

[VahidDM]

Hi @admin11 

You need to use the Analyses Pane:

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-analytics-pane

In the Line select the column that you want to use and set the aggregation to average.

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[admin11]

@VahidDM 
Thank you for sharing. may i know where i can set an average line ? now i only able to enter a value for the line. 

[VahidDM · Accepted solution]

@admin11 

Click on FX button, select the column and set the aggregation to Average.

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

 FIFA World Cup - Medal Records