To create a shift roaster in Power BI

Question

Hi All,I have a requirement to create a shift roaster in power BI, below is the format given in Weeks.I have to display Weeks along with timing PST and highlight the shift details during this time.In Power BI expected output should be like below displaying time and week and highlight the time with shift details&nbsp;Please help how can we achieve this.&nbsp;Thanks in Advance,Neelofar Shama&nbsp;

amitchandak · Answer

Anonymous , Separate out Data and time in separate columns 
create Date and Time table.
&nbsp;
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/
&nbsp;
Date = [datetime].date orDate = date(year([datetime]),month([datetime]),day([datetime]))
&nbsp;
Time= [datetime].Time orTime= date(hour([datetime]),minute([datetime]),second([datetime]))
&nbsp;
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.

harishkm · Answer

Anonymous&nbsp;you can create a custom calender .Calender = ADDCOLUMNS( CALENDAR(MIN(data[Order Date]),MAX(data[Order Date])),"Year",YEAR([Date]), "Monthnum",MONTH([Date]),"Month Name ", FORMAT([Date],"mmmm"), "Day", DAY([Date]),"Day Name", FORMAT([Date],"dddd"),Then drag the required feild in matrix for result like this&nbsp;&nbsp;