Forum Discussion

lekkerbek's avatar
lekkerbek
Helper IV
9 years ago

Date sorting in Matrix

Hi,

 

I have created a matrix and I put the date in the columns field.

 

It gives me the information I want, but I want to start with the most recent year and previous years should be more to the right. It now starts with the oldest year available.

 

Is it possible to change the order in the Matrix visual?

Need Help

7 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    9 years ago

    Sounds like you just need to adjust the order in the Rows section of the visual, you can just drag and drop the columns to change the order.

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    9 years ago

    Hi lekkerbek,

    As the Greg_Deckler posted, please click the triangle button highlighted in red line at the column hearder, order by data ASC or DESC. 

     

     

    If this doesn't resovle your problem, please post detail information or screenshot.

     

    Best Regards,
    Angelia

    • lekkerbek's avatar
      lekkerbek
      Helper IV
      9 years ago

      Hi,

       

      I believe you are referring to a table? My problem is with the matrix.

       

       

      • v-huizhn-msft's avatar
        v-huizhn-msft
        Microsoft Employee
        9 years ago

        Hi lekkerbek,

         

        It's a matrix, I don't add the legend level, so it likes table. Based on your description, you can choose data rather than hierarchy.

         

         

        Best Regards,

        Angelia