Forum Discussion
Matrix Sort Order by Month and Year Problem
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
Still no go. I'm thinking I have a problem to fix in the one to many relationship. I can't sort any column with multiple values by a column that has unique values without getting the same error for different columns.
The data type is "Text" on Month column.
Please change it to Date format and it should work.
Mond - Changing data type only caused errors.
