Gannt Chart but based on hours of day instead of dates

[tagban]

Is there a way to use the various Gannt Charts to display time instad of dates?

Scenario:
I have 4 employees that do a variety of work, I have start/end datetime formatted for each task, but some tasks overlap. I want to show that type of overlap.

Ideally I have a 3rd scenario of also overlapping their user status (Think away/busy/available in teams)

So the idea is

User | Start Time | End Time | Task Type | Duration (seconds)

1 | 1/29/2024 9:00:00 AM | 1/29/2024 9:02:00 AM | SMS | 120
1 | 1/29/2024 9:01:00 AM | 1/29/2024 9:04:00 AM | EMAIL | 180
1 | 1/29:2024 9:00:30 AM | 1/29/2024 9:15:00 AM | CALL | 870

So this would show as

User 1
 SMS  [|||]
 EMAIL [|||]
CALL  [|||||||||||||||||||||]

And my ideal state would also show their status as a line or somethin but I can do that in a seperate visual following the exact same logic as this as our users are considered available if not on a call and not on more than 5 open SMS/Email tasks.

I'm just struggling to find the right visual, maybe its not a thing and if not thats OK but I wanted to ask here incase I'm just missing something fairly obvious. 

This chart would be displayed for one user at a time, just to show how busy they are, and because they can have multiple SMS/EMAIL I'd expect a different line for each. 

[Anonymous]

Hi @tagban ,

Perhaps you can learn about this below:䷥ Office Timeline: Hourly Gantt Chart template

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

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

[tagban]

That doesn't appear to be related to PowerBI?

[Anonymous]

Hi @tagban ,

Please check if the following results meet your needs:

An attachment for your reference. Hope it helps!

Best regards,
Community Support Team_ Scott Chang

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

[tagban]

So with your example I did figure out where they hide the hours so I can show time instead of days. Is there any other customizations to this visual IE a dark line between each item? I seem to have a lot that run together. 

[Anonymous]

Hi @tagban ,

I'm sorry I can't help you more.Based on the above information, if you are a Power BI Pro licensee, you can create a support ticket for free and a dedicated Microsoft engineer will come to solve the problem for you.
It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.

The link of Power BI Support: Support | Microsoft Power BI

For how to create a support ticket, please refer to How to create a support ticket in Power BI - Microsoft Power BI Community

Best regards.
Community Support Team_Scott Chang

[tagban]

Its pretty much what I got as well. I can only seem to see the date range at the top of the charts so of course it starts all items at the very begining of the hour. I'd prefer to see it at the point of each hour it actually starts/ends, with overlapping potential. That's what makes this confusing for me, is that most PowerBI stuff seems designed to do dates and not time as well.