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!
Anonymous,
you can sort Month by Date instead. Click on your Month in the Fields pane --> Modeling Ribbon --> Sort by Column and select Date
NickNg278 - If I understand correctly I have already done that.
Anonymous,
select Date instead of Month (Default)
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.