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: ...
Need Help
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.

molesterman's avatar
molesterman
New Member
2 years ago

Hi Thank you very much for the reply ! I really appreciate that. but it doesn't seem to work as the original data contains 40k+ rows. it DOES show a graph though, however it does not visualize the whole trend, the graph is too "zoomed in".

I was going to upload my data but it doesn't allow me to upload the file. Do you mind taking a look at my data? I uploaded it to google spreadsheet. https://docs.google.com/spreadsheets/d/1c1pe-ED-7sHrxTRPNkWRim0I6x-wLXY9yMvQjmpXi3k/edit?usp=sharing