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 l...
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!
My apologies NickNg278 - I was in the process of rereading and doing what you had correctly written before and found my mistake. Having done that I get this error.
Anonymous,
No problem. You can create another column in your date table using this format "YYYY/DD" (YearMonthnumber) then sort your Month by YearMonthNumber