Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Cant sort datetime column in matrix

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 ...
Need Help
v-danhe-msft's avatar
v-danhe-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

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's avatar
    Anonymous
    Not applicable
    7 years ago

    The data type is datetime, please find the screenshots below

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Is there anyone can help me with this issue?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    The data type is datetime, please find the screenshots below

    • v-danhe-msft's avatar
      v-danhe-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      7 years ago

      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