Forum Discussion

lekkerbek's avatar
lekkerbek
Icon for Helper IV rankHelper 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...
Need Help
v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft 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
Icon for Helper IV rankHelper 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
    Icon for Microsoft Employee rankMicrosoft 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

    • lekkerbek's avatar
      lekkerbek
      Icon for Helper IV rankHelper IV
      9 years ago

      Ah I see what you mean, but my date is the columns section (and needs to be there for the correct presentation). 

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

        Hi lekkerbek,

        As I tested, we are unable to order the data directly in column level in Matrix visualization. Please review this article. Thanks for understanding.

         

        Best Regards,
        Angelia