Forum Discussion

kattlees's avatar
kattlees
Icon for Post Patron rankPost Patron
8 years ago
Solved

Timeline 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 ...
Need Help
  • OwenAuger's avatar
    OwenAuger
    8 years ago

    kattlees

    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

     

     

captainlaw's avatar
captainlaw
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Do you mind sharing your solution how to round when there's a StartTime & EndTime?

captainlaw's avatar
captainlaw
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

I'm wondering if there are other visuals that could in-take StartTime & EndTime and provides a count?

  • kattlees's avatar
    kattlees
    Icon for Post Patron rankPost Patron
    8 years ago

    I am not sure