Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Order Matrix ascending

Can anybody help me? I currently have in this matrix the date from 03/24/2021 to 04/01/2021 but I would like to put it in ascending order.

Wrong Image




Correct Image - ( I used photoshop to demonstrate how I want )


I'm using standard date "dd/mm/yyyy" 


Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    Hi Anonymous 

    It works fine for me in a matrix.  If the dates are dates then it should auomatically sort them correctly.

     

    Have you got the matrix sorted in Ascending or Descending order?  Click on the ellipsis ... to check 

     

     

    Can you please supply your data and/or PBIX file if this doesn't fix it.

    Regards

    Phil

3 Replies

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    5 years ago

    Hi Anonymous 

    It works fine for me in a matrix.  If the dates are dates then it should auomatically sort them correctly.

     

    Have you got the matrix sorted in Ascending or Descending order?  Click on the ellipsis ... to check 

     

     

    Can you please supply your data and/or PBIX file if this doesn't fix it.

    Regards

    Phil

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thanks for your response PhilipTreacy 
      I uploaded my database that I am using. Link Wetransfer 

      I replied the way you did and it seems that you are increasingly ordering by values.

      If I change the same spreadsheet with different values ​​it looks like this

      In my real case I have this database Link Wetransfer 
      and replicating for that same method was as follows.