Creating an Average Line within a line chart

[Ruz]

Hi

I have a Line Chart with setup suc that Month as the x-axis, year as the legend, and my values with many data points averaging on the y-axis as below.  I want to add a line to this chart where I average by the month to show a trend. What measure could I use to add that line? 
If it is not possible, alternatively I am looking for average to appear on tooltip like below.

Thanks

Ruz

[Anonymous · Accepted solution]

Hi @Ruz ,
To add a line to the chart to show the average value by month, you can create a new metric to calculate the average of each monthly value.

Avg =
AVERAGEX ( GROUPBY ( 'Table', 'Table'[Month] ), AVERAGE ( 'Table'[Values] ) )

Final output:

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.