Power Pivot - grouping timestamps by hour is not in incremental order

Hello

When I have had the occasional success in grouping timestamps in a Power Pivot table, I typically group it based on hour and day. However, grouping the timestamps by hour will not be sorted in incremental order. This is a little strange, but whenever I ungroup, it is sorted in the correct order.

I have had it occured with multiple different csv files, so it isn't unique to a particular file.

What could be the cause of this and is there anyway to fix this?

Thanks

Edit: Added the individual files as needed. Since there might be a possibility that I might be doing something wrong in the Power Query, I have also attached the csv that I have been using.

No, but I am not gonna use a zip file.

So if you add a small excel file I can take a look at it.

I've I create a pivot table from the CSV file I can group by day and hour and everything seems correctly sorted, see the attached workbook.

What steps are you following to group the data in Power Pivot?

If you open Power Pivot after you have grouped the data you should see that the formula for the 'hour' column is using the TEXT function which returns text that's why the data isn't sorting correctly.

Change the formula in that column to use HOUR to extract the numeric hour.