Forum Discussion
Post PatronTimeline Visual to Show Usage During the Day
It seems that the "as Timeline" custom visual gets close to what you want.
I created a dummy pbix with your sample data here
I can't say I'm completely happy with the formatting options though - I had to create a dummy column to colour the bars by room.
There are a couple of Gantt custom visuals available as well that you could play around with (Gantt and Gantt Chart By MAQ Software).
Regards,
Owen
Post PatronThis one rounds down so 3:21 becomes 3:00
TimeIn = IF(MINUTE('Pre Op Times'[Time In])<30,TIME(HOUR('Pre Op Times'[Time In]),0,0),TIME(HOUR('Pre Op Times'[Time In]),30,0))
This one rounds up so 3:21 becomes 3:30
TimeOut = if(MINUTE('Pre Op Times'[Time Out])>30,TIME(HOUR('Pre Op Times'[Time Out]),59,0)+TIME(0,1,0),TIME(HOUR('Pre Op Times'[Time Out]),30,0))
Microsoft EmployeeBut the goal is not just bucket StartTime & EndTime, the goal is associate count for all times in between StartTime & EndTime. I mentioned it in my example below -
StartTime EndTime
2018-01-01 08:15:51 2018-01-01 10:45:31
2018-01-01 09:45:51 2018-01-01 10:15:31
2018-01-01 13:24:51 2018-01-01 17:05:31
2018-01-01 15:17:51 2018-01-01 18:42:31
2018-01-01 07:15:51 2018-01-01 11:58:31
Final Result - a timeline chart that shows at any given time, the count. For example, at 10 am sharp, the count should be 3 (1st, 2nd, and 5th records above).
I'm not sure which visualization provides the best approach for this?
Thanks!
- kattlees
I'm sorry but I am not the one to help. I am so new to Power BI that I ask for help almost daily. I would suggest starting a new thread. There are so many knowledgeable people on here that could help you.
- captainlaw
I just thought this thread had many similar ingredients that could help me find a great visual for my case.
I did start a new thread below on 8/18, but haven't received a response/solution yet.