To create a shift roaster in Power BI

Anonymous , Separate out Data and time in separate columns

create Date and Time table.

Time table , create bucket of time you need - https://kohera.be/blog/power-bi/how-to-create-a-time-table-in-power-bi-in-a-few-simple-steps/

Date = [datetime].date
or
Date = date(year([datetime]),month([datetime]),day([datetime]))

Time= [datetime].Time
or
Time= date(hour([datetime]),minute([datetime]),second([datetime]))

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.