EDIT: I figured the right way to show hours (DATEPART function) and combined with Simon's answer. Thanks!
Thanks Simon. The current hour dimension is in time format. So I duplicated the dimension because the Create Bin option didn't appear initially, then did Create Bin on the new dimension. However, the new dimension is now not in the standard time format. Is there a way to create the bins for a timestamp, extracting the hour?
So I think if you just take the date part of hour from your datetime field, and then bin on that.
DATEPART('hour', [Your DateTime])
This should just return the hour 0,1,2,3....22,23 so ends up being just like the example you posted.
Let me know if that doesn't work.