put yearly trend line in data and ignore month

[CL7777]

Hi,

Im struggling with this one.. I have a table of data that has part number, store, quantity sold, and a few other columns.

I created a column chart that has the quantity sold with date on the x axis (the date includes just month and year). I want to add a line on this plot (so have a line and clustered column chart) that shows the annual average of quantities. When I add a line for average quantity to this chart, it filters it by month also (because the x axis has month and year). I want the yearly average line for each year on the chart. I also want to be able to filter by part number and store and have the annual average line change with the data. How do I put an annual average line on a chart and ignore the filter caused by the month part of the X axis?

Thanks for your help

[v-chuncz-msft · Accepted solution]

@CL7777 

You may add the measure below.

Measure =
CALCULATE (
    AVERAGE ( 'Table'[quantity] ),
    ALLSELECTED ( 'Table'[Date].[Month], 'Table'[Date].[MonthNo] )
)