Line Graph with 10 Minute Intervals on x-axis! Help

[lotuzzdiabetes]

HI
i have data with time column. i want to have new column which will divide calendar with 24 hour intervals starting at 09:00 of each day. like this:
01/01/2018 09:00
01/02/2018 09:00
01/03/2018 09:00

01/04/2018 09:00

[v-yulgu-msft · Accepted solution]

Hi @lotuzzdiabetes,

Please add a custom column in Query Editor:

=List.DateTimes([Time interval 24],144, #duration(0, 0, 10, 0))

Best regards,

Yuliana Gu