Forum Discussion

ConnieMaldonado's avatar
ConnieMaldonado
Icon for Responsive Resident rankResponsive Resident
6 years ago
Solved

Stacked Bar Chart with Start Time, Duration and Multiple Activities on One Row

I'm creating a report to review the efficiency of technician activities on a daily basis.  I'm looking at 3 categories of effort:  work (actual time on the job), drive time, and comparing that to act...
Need Help
Tutorial Requests
  • v-alq-msft's avatar
    v-alq-msft
    6 years ago

    Hi, ConnieMaldonado 

     

    Based on your description, I creatad data to reproduce your scenario.

    Table:

     

    Duration is a calculated column as below.

     

    Duration = DATEDIFF('Table'[Start time],'Table'[End Time],MINUTE)

     

     

    You may use Gantt 2.2.3 from marketplace, go to 'Visualization' ribbon, click 'Formatting'=>'General', set 'Duration unit' as 'Seconds' and 'Duration min' as 0, click 'Date type', set 'Type' as 'Hour'.

     

     

    Result:

     

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper User
6 years ago

Hi ConnieMaldonado 

 

I'd recommend getting a gantt chart from the visual store for this. It should work just fine with your current data format.

I get the following results with the Gantt Chart by MAQ Software:

 

There may be some work to do on chart scaling etc., or you may find another visual that works better, but a start.

 

Pete

Mariko01's avatar
Mariko01
New Member
2 years ago

Could you clarify which type of file you're looking for an example of? If you're trying to adjust the axis to show time intervals like "12:00 AM" and "12:30 AM", I can guide you on how to change the axis settings for that.