Sort based on month year in line chart

[raj777karthik]

i need to sort customers based on Month year asc.

For example in my line chart X axid it get sorted 01-18,01-19,01,20, 02-18,02-19,02-20 but my logic i have to sort like 01-18,02-18,03-18 and 01-19,02-19,03-19.

 I have used calculated column 

MonthYear date = FORMAT(Date[CreatedOn Date],"MM-YY")and this is text format as well.

Let me know how can i sort.Any helps appreciated

[amitchandak · Accepted solution]

@raj777karthik , Create one more column

MonthYear Sort= FORMAT(Date[CreatedOn Date],"YYMM")

Now click on your column, in column tool -> use sort column and choose this new column

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c