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!
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.