Forum Discussion
Post PatronTimeline Visual to Show Usage During the Day
I would really like to find a way to show the usage of a Room during the day.
My table has
Room Start Time End Time Date
1 07:00 07:40 4-6-18
1 08:00 08:45 4-6-18
1 10:25 11:00 4-6-18
2 07:15 09:20 4-6-18
2 09:30 11:00 4-6-18
I would love the visual to end up like this: Please tell me there is something I can do to get this.
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
20 Replies
- OwenAuger
Super User
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
kattleesIs there a way to set the start time to like 6:30AM instead of the midnight?
Your solution was perfect. I didn't have my time fields as time -they were set to text for some reason.
- OwenAuger
That's good news :)
For me, the time axis was starting at 7:00 (start time of first event), so not sure why you may have been getting midnight.
I tried creating a dummy event with zero duration starting at 6:30 am, and this forces the time axis to start at 6:30.
See same Dropbox link for updated file.
