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...
Need Help
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

  • lekkerbek's avatar
    lekkerbek
    Helper 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
      Microsoft 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

      • lekkerbek's avatar
        lekkerbek
        Helper IV
        9 years ago

        Thanks for your suggestion. I get the following error when doing that:

         

        Expression.Error: We cannot convert the value #date(2016, 12, 31) to type Number. Details: Value=31-12-2016 Type=Type

         

        Perhaps I should just wait untill the feature is implemented.