YOY Line Chart

Hi v-juanli-msft,

Thank you for your response.

I followed your instructions but something is different with my Power BI.

I added the "year" column to the main table then set the BookingDate data format to "d MMMM" since I can't find the format you suggested on the selection as shown below.

I then add the "BookingDate" as axis and "year" as legend but the axis still shows the complete date even after changing the format as shown below. Also noticed that the BookingDate didn't show the heirarchy under Axis.

I was able to somewhat achieve the desired chart by creating a new column "BookingDate (MMM DD)"  which is just equal to "BookingDate" and is formatted to "d MMMM". Also, it shows heirarchy when added as Axis.

The issue with above chart is that it does not show the entire 1 year data, you need to scroll horizontally to view the other data. I want to show the entire 1 year data same as 2nd image above.

Also, there is no option to add a trendline for each year which is important to me.

Additional Notes:

A date filter will be added so the date range can be shorten.

Using "BookingDate (MMM DD)" as filter is not possible since it still contains years data and shortening the range will remove the years that is not part of the range.