Do not want year in x axis

[cjindal]

I have dataset with dates. Data is like this:

I need my visual to compare numbers year over year. Problem is that X axis always show me 1900 as year. I want to see days and months only. It work for months but not for days and months together.

I created a new custom column as 

Day2 = FORMAT(Query1[VALUE_DATE],"DD-MMM")

It gave me the format of x-axis i need but it is now sorted as text and not jan to dec.

[v-yuezhe-msft · Accepted solution]

@cjindal,

Please check the following video. I show an example about how to create the Line chart.

https://1drv.ms/v/s!AhsotbnGu1Nok1MtybKxD2cAWrol

Regards,
Lydia