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 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
Icon for Helper IV rankHelper 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.