Cant sort datetime column in matrix

[Anonymous]

I created a customized sql query in the data model, I dragged a datetime as well as other categories into Rows, and some values into Values, but I found the datetime sort is not working. I can't add a index for the datetime, because I want to sort other columns.

[v-danhe-msft]

Hi @Anonymous ,

Based on my test, it could work on my side:

Could you please check if the format of your data is time?

Regards,

Daniel He

[Anonymous]

The data type is datetime, please find the screenshots below

[v-danhe-msft]

Hi @Anonymous ,

Sorry to reply you late. I have tested with matrix befor and the result is always work on my side:

I could not reproduce your problem, maybe you could create a support ticket for more help:https://powerbi.microsoft.com/en-us/support/

Regards,

Daniel He

[Anonymous]

The data type is datetime, please find the screenshots below

[Anonymous]

Is there anyone can help me with this issue?