Showing moving averages for multiple years on a line chart

[DAX_pbi_learner]

Hello. So the average interval calculations show up correctly when I set up the chart like this and the shape of the graph for each year is exactly how I want it to be when I toggle between daily, 7 day, and 30 day movign averages and hover on the graph for detail data. However, the data for all years is on one line. I'd like it to be separate for each year (to show comparision) and have the x-axis as months.

When I adjust the date hierachy to get the x-axis to display Months and have the lines for each year separately as I'd like, I am unable to get the data to look as I like aka continuous.

@amitchandak 

[DAX_pbi_learner]

Thanks @lbendlin I was able to get the chart to look how I wanted by using a date column for one year:

I randomly picked all days in 2020 for the x axis...however, now it shows up as Jan 2020, I would like just Jan to show up..any ideas on how I can go about that?

I even changed the format type but that doesn't seemt to affect the line Chart X-Axis

[lbendlin]

I think you need to change the format directly on the visual, not in the base table.

[lbendlin]

Don't use months as the X axis.  

Creating a simpler and chart-friendly Date table in Power BI - SQLBI