Forum Discussion
raj777karthik
Microsoft Employee
Microsoft EmployeeSort based on month year in line chart
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-1...
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
amitchandak
Super User
Super Userraj777karthik , 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