Forum Discussion

damit23183's avatar
damit23183
Microsoft Employee
5 years ago
Solved

Sorting by Month in Matrix Table

Hi,   I am trying to sorting out Matrix table by month.   As you can see I have in alphabet order; but I would like to see in Calendar order.   I am using three columsn in Matrix , Year, ...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    5 years ago

    damit23183 

    Sorry, I may be misunderstanding what you have done, but...

    The date table should be sorted by the date column. 
    To sort the Month Name column, you need to select it and then use the "Sort column by..." and choose the month number as the sorting column. 
    They are two seperate "sorting" operations

  • PaulDBrown's avatar
    PaulDBrown
    3 years ago

    If you have a measure, you can create a new measure using SWITCH to create the order measure and use that as as the sorting criteria

PaulDBrown's avatar
PaulDBrown
Community Champion
5 years ago

damit23183 

Sorry, I may be misunderstanding what you have done, but...

The date table should be sorted by the date column. 
To sort the Month Name column, you need to select it and then use the "Sort column by..." and choose the month number as the sorting column. 
They are two seperate "sorting" operations

damit23183's avatar
damit23183
Microsoft Employee
5 years ago

Hi,

 

Got it now Actually I misunderstood and focusing on one sorting only.

 

Now, I get it there can be two sorting possible for each column.

 

Thanks a lot for feedback.

 

Thanks

  • PaulDBrown's avatar
    PaulDBrown
    Community Champion
    5 years ago

    damit23183 

    Happy to help! Please mark the relevant post as the solution to close the thread and help others searching for a similar solution.

    Thanks!