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

[ConnieMaldonado]

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 actual clock in/out time.  In any event, I need a bar chart that has start time on the horizontal axis, and category on the y-axis.  For each category, I need to see all activities on a single row.  A couple of questions:

1. How to get the start time on the x-axis? 
2. How do I group all activities for each category on the same row?

Thanks.

[Vishnu_Kas]

Hi @ConnieMaldonado @BA_Pete @kewaynes @v-alq-msft ,

I have a quick query in regard to how to use a stacked bar chart in Power BI which would show the category vs. Time.

I was able to create one in Excel using time series But trying to figure out the same in Power BI Visual.

It would be really helpful if someone could share their thoughts on the same. Please feel free to reach out to me on any additional information.

Excel Graph:

I colored the cells of Layover to White (So it shows as a gap), Blue highlighted are all Travel times.

Raw data Sample: 

ID Number

Start Time

Travel

Layover

Travel

Layover

Travel

Layover

Travel

Layover

Travel

Layover

Travel

3

05:25:00

00:23:00

00:07:00

00:31:00

00:14:00

00:30:00

00:15:00

00:42:00

00:18:00

00:40:00

00:20:00

00:36:00

4

05:25:00

00:23:00

00:07:00

00:25:00

00:05:00

00:32:00

00:13:00

00:40:00

00:20:00

00:45:00

00:15:00

00:37:00

Regards

Vishnu

[BA_Pete]

Hi @Vishnu_Kas ,

I suggest that you open a new post in the Desktop forum for this:  Desktop forum 

You'll have a far higher chance of getting a quick resolution there.

Pete

[v-alq-msft · Accepted solution]

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.

[kewaynes]

Is there any way to get this to be a constant scale? For instance, in the below, I want it to show all the hours of the day and not just based on the time the vehicle was working...

[ConnieMaldonado]

Thanks  Allan.  Big help.  Thank you.

[BA_Pete]

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]

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.

[ConnieMaldonado]

Thank you!  I tried the exact same visual and another one as well - the issue (as you said) is scaling.  I can't get the hourly time scale.  I even reached out to MAQ who said they'd add hourly time scale to the backlog.  Also, the time is added by category, rather than allowing multiple activities on the same row.