How do I get the time to sort by order rather than by the value?

Add a calculated column that shows the number of minutes passed in a day until your interval time. Then sort your interval column by that new column. If you get a circular reference error you can add the new column in Power Query instead.

Hi Anonymous,

You can take a look at the following to add a custom 'sort order' table to specify the order of your table records. 

Custom Sorting in Power BI 

You can add a custom column to extract the hour value and create a custom table from 0 to 23 and set the sort order with offset 8 as index and link to raw table 'hour' column.

Regards,
Xiaoxin Sheng