distinct values from date/time column

[AI14]

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

[tamerj1 · Accepted solution]

Hi @AI14 
Create a time only column like TIMEVALUE ( 'Table'[DateTime] ) then use it in the x-axis of the chart