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
Super UserIt 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 PatronIs 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.
- kattlees
I found the timeline issue and it is fixed. Is there any way to get labels in the bar colors?
- captainlaw
Microsoft Employee
Thanks for sharing about this great custom visual. I have a similar problem to solve but I wasn't sure if this visual could achieve the following requirement -
I would like to show by "continuous" timeline on x-axis of a KPI metric, which has StartTime + EndTime attributes in the dataset. The tricky part is how to allocate the count across the timeline. Each record below is 1 count.
ie
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?
Can any of you help point me in the right direction?
Thank you!
