Power BI timestamp chronological order

Question

I'm trying to apply a top N filter for timestamp within a push dataset visualization (I'm trying to get the last 10 rows in real time), however, it seems it's not displaying the data in a chronological order. Can anyone give a tip on this one?

Answer 1

I have managed to find the issue. Timestamp was pushed as string instead of date, that is why I was able to choose top N filter (which doesn't work with dates by the way), and since it was treated as a string, it didn't order the dates chronologically. I changed it to date and I can work with the relative date filter now, however, the data shown is maximum each 30min, I cannot "zoom" in to see it in the last 10 min, since with this type of filter you can do it by day for example but not min, sec, etc...

Can you think of any other solution?

image of tile here

Answer 2

Without seeing an example of your data. I would try checking the data type of the date field you are trying to order first. You can do this by selecting edit query:

Find the column of the timestamp you need to check and look at the data type. You may need to change it to a date or date/time. Apply the changes if any were made.

If that doesn't help there are other things to try next.

Answer 3

How are you displaying these rows? In a table? Check the sorting order of the visual, i.e. look for the triangle next to some column title and click on your timestamp column to sort on it.