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

     

     

OwenAuger's avatar
OwenAuger
Icon for Super User rankSuper User
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

 

 

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

    Is 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's avatar
      OwenAuger
      Icon for Super User rankSuper User
      8 years ago

      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's avatar
        kattlees
        Icon for Post Patron rankPost Patron
        8 years ago

        I found the timeline issue and it is fixed. Is there any way to get labels in the bar colors?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi,

     

    I have downloaded the PBIX, I see you have added a dummy column, but I am not able to find the logic you have written to colors the bars based on room number? 

     

    Could you please help me?

  • kady's avatar
    kady
    Regular Visitor
    4 years ago

    OwenAuger  hello Sir, is there any chance to get a copy of your file for this topic?

    Thank you in advance,

    • OwenAuger's avatar
      OwenAuger
      Icon for Super User rankSuper User
      4 years ago

      Hello kady 

      The Dropbox link appears to still be working, but I have edited my post to include a traditional attachment of the same file.

      Regards,

      Owen

  • LeoM_'s avatar
    LeoM_
    New Member
    4 years ago

    Your solution fit very well for what I am pretending to do, thanks! 

    Some values, in my case, the start time of a activity is in a day and it finish in the next day. In that way the chart does not keep in a 24h interval that I want. Any tips? I would like to transfer the hours from the next day in the chart to the same hours im the current day.

    • YashMistry's avatar
      YashMistry
      New Member
      3 years ago

      Hi LeoM_  I could not find "As Timeline" Visual. Can you provide me with the .pbiviz file.

  • YashMistry's avatar
    YashMistry
    New Member
    3 years ago

    Hi OwenAuger I could not find "As Timeline" Visual. Can you provide me with the .pbiviz file.