Expand hours in days based on start and end date

[Anonymous]

Hi Power BI experts! 🙂

I have a table like

I need to a graph to show each day as 24 hours and hours' duration for each item. Like

01/01/2023 A:11 hours, B: 14,5 hours

02/01/2023: A: 1 hour B: 5,5  C: 1 hour and D 14 hours

03/01/2023: D 2,0 hours 

[Anonymous]

Hi @Anonymous ,

You can create a gantt visual as below screenshot to achieve it, please find the details in the attachment.

In addition, please review the solution in the following links. Later check if they can be used as an workaround...

Solved: timestamp - last 24 hours on x axis (for me its sh... 

Solved: Shift Report over 24hr clock by Time and Day

---

Here is how I would approach this in a matrix visual.

1.  Make a disconnected table of times in the query editor with = List.Times(#time(0,0,0),96,#duration(0,0,15,0)), convert to table, rename it, and load it.  

2. Make a matrix visual with this new column as the columns

3.  Use a measure like this to count the number of people working during that timeslot.  TimeSlot is the table with the 15 min increments from step 1)

You should be able to use your Date column on rows in the matrix.

---

Best Regards