Forum Discussion

Lio123's avatar
Lio123
Advocate I
1 year ago
Solved

Help with sorting the matrix

Dear developers,  I need your help to sort the matrix visuals based on months, along with months I have some other values as well in the columns, you can put them at last after months.  Please ...
Need Help
  • Lio123's avatar
    Lio123
    1 year ago

    Hi wardy912  & mdaatifraza5556 

    Thank you for your reponse,

    I have date dim table and month sort column as well,.

    The issue was with other values apart from month values, so I just added the custom sorting column in PQ and then sorted the month column in the report view and it worked. 

    Regards

mdaatifraza5556's avatar
mdaatifraza5556
Super User
1 year ago

Hi Lio123 


Did you try creating a Month Number column in the Date table and then sorting the Month Name column by that Month Number?

Follow to get it 

Create Month No column for sorting 


 

 

Click on month name column and then sort by column from the ribbon and select month no.

 

 

 

 

Result

 

 




If this answers your questions, kindly accept it as a solution and give kudos.

  • Lio123's avatar
    Lio123
    Advocate I
    1 year ago

    Hi wardy912  & mdaatifraza5556 

    Thank you for your reponse,

    I have date dim table and month sort column as well,.

    The issue was with other values apart from month values, so I just added the custom sorting column in PQ and then sorted the month column in the report view and it worked. 

    Regards

    • wardy912's avatar
      wardy912
      Super User
      1 year ago

      Glad the issue is resolved, please help others by marking as solved.

      Thanks!