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!

Mond's avatar
Mond
Helper III
8 years ago

Hi Hanley,

 

I got a question, when your Date coulmn show value (1/1/2000), how come Month value shows "Jan05".

 

Can you please duplicate Date column and use Data Type = Date, and Format (MMMM yyyy)

 

 

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!