Forum Discussion
Matrix Sort Order by Month and Year Problem
I have a date table with added columns, created a relationship, date slicer and matrix visual and cannot seem to find the reason the sort wont work correctly. December should not be first. I would like to sort by month/year with the oldest first. I also have the date table marked as date. What am I missing?
Thank you,
Mond - Your suggestion got me in the ball park for the next step. I'm sure you would have done something similar but I found an answer here: https://community.powerbi.com/t5/Desktop/how-to-sort-Date-MonthYear-column/td-p/102700
I did what Tri Nguyen suggested by adding another numerical column which I could sort my MonthYr column by. It is multi to multi relation but not text. Worked perfectly. Thank you both!