Forum Discussion
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-19,02-19,03-19.
I have used calculated column
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
1 Reply
- amitchandak
Super User
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