Forum Discussion

jburrelli's avatar
jburrelli
Frequent Visitor
7 years ago

Date ordering is incorrect

In my report, I sorted the date/time column in descending order. I noticed that it is mixing the dates up as I scrolled down further. Please see my screenshot for example 

Need Help

6 Replies

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    7 years ago

    jburrelli  its really hard to tell without seeing what you doing in the model.  firstly what data type is your date set as? 

    • jburrelli's avatar
      jburrelli
      Frequent Visitor
      7 years ago

      Hi Vanessa,

       

      The data type is set to "Date/Time/Timezone".

       

      Thanks

      • Tahreem24's avatar
        Tahreem24
        Super User
        7 years ago

        Hi,

         

        Could you please give the screen shot of your date's data type? SO that it would be more feasible to answer your question.

         

         

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    Hi jburrelli ,

    From your image, it seems that your data order is ascending. By my tests with part of your data, I cannot reproduce your issue.

    If it is convenient, could you share some data sample with table format so that we could help further on it?

    In addition, please check if you have install the latest version of power bi desktop.

    Best Regards,

    Cherry

     

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    Hi jburrelli ,

    Have you solved your problem?

    If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

    If you still need help, please feel free to ask.

    Best  Regards,

    Cherry