s

Anonymous , This based sort order.

 

example

hour = hour([datetime])

 

hour sort = if( hour([datetime]) <= 6 , hour([datetime]) +18,  hour([datetime]) -6) 

 

sort hour on hour sort https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column