Need help with stacked bar chart with variable data columns

[freakdaddy]

I'm trying to represent a timeline of multiple phone agents activities.  Activities are represented starting at a point to time (datetime) and have a type (available, on call, on break, etc) and a duration.  The visual I am trying to create is similar to a horizontal stacked bar chart however the activities are variable per agent and I would like the types to always be represented by the same color.  I have included data and a manually created representation of what I am trying to accomplish.  Is there a way to do this with power bi?

Agent	datetime	duration	Type
agent1	12/20/2023 08:00	1	available
agent1	12/20/2023 09:00	.25	break
agent1	12/20/2023 09:15	.5	on call
agent1	12/20/2023 09:45	1	available
agent1	12/20/2023 08:00	.75	on call
agent2	12/20/2023 08:45	2	available
agent2	12/20/2023 10:45	1	on call
agent2	12/20/2023 11:45	1.5	on call
agent2	12/20/2023 13:15	1	lunch

[freakdaddy]

The way that table was formatted by the forum distorted the data.  There is a datetime column which for example should show "12/20/2023 08:00" and then there is a duration of "1".  Furthermore your example is apparently grouping the activities unlike shown in my example.  Agent1 has 2 activities on their timeline where they were "available" and the bar chart should match that.  In total agent1 should have 5 bars in their timeline while agent2 should have 4.  Also it shouldn't be a type 100% bar chart because the datetimes start and end at different times per agent.  (I didn't do a good job of showing the difference in start times on my hand drawn chart)

Here is a better example chart...

[Anonymous]

Hi @freakdaddy ,

If I understand correctly, the issue is that you want to show a timeline of multiple agents activities with stacked bar chart. Please try the following methods as a workaround:

1.Create the simple table. 

2.Select the Stacked bar chart visual.

3.Move the agent field into the Y-axis and move type to the Legend.

4.The result is shown below.

Alternatively, you can also use a column chart to implement a timeline of agent activity.

Solved: Multiple variables in a stacked column chart in po... - Microsoft Fabric Community

Looking forward to your reply.

Best Regards,

Wisdom Wu