Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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's avatar
Anonymous
Not applicable
8 years ago

Great catch Mond - I had not added the table/column name correctly. I had only DATE when it should have been DateTBL[Date]. That gives me the correct MonthYear (Jan00) but I still cannot change format from Text to Date or sort column by Date column with out the errors. Nor fix my original problem of sorting in the correct order.

 

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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!