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 a index for the datetime, because I want to sort other columns.

Need Help

5 Replies

  • 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