distinct values from date/time column

Hi,

What formula or technique can i use to only return distinct time values from a date/time column.

the column shows start of hour ( possible times: 04:00 - 23:00) however i use a date slicer which if i choose a 7 day range i still only want the distinct time range on my x axis.

01/03/2023 04:00

01/03/2023 05:00

02/03/2023 04:00

02/03/2023 05:00

this should only show me:

04:00

05:00

the data is direct query so i cant change the type to time, only on the report page.

Thanks,

AI