Forum Discussion

molesterman's avatar
molesterman
New Member
2 years ago

Help - Time stamp sort in a row order

There is a raw dataset of 40k rows+ as below:

 

This data starts from the time stamp of 17:23:22 and ends in the next morning. When i import this data into power bi I run into this problem:

 

Power bi automatically recognizes that it started from "00:00:00", it sorts the data automatically ! the data ends at 5 in the morning, power bi plots a wrong graph because there was no data provided between the two time stamps.

 

I tried sorting time stamps but there is no sorting option available!

 

 

I even tried making an index and sorting by it but it didn't solve the problem... 

 

Is there any recommendation to solve this problem?

 

 

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi molesterman ,

    Based on your description, I created the following data.

    Thanks for the inspiration, I have created the index column.

    I then put the index column into the x-axis as well, noting that the index column should be on top.

    The results obtained are shown below.

    If your Current Period does not refer to this, please clarify in a follow-up reply.

     

    Best Regards,

    Clara Gong

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.