How to show the remaining time in a stacked bar column

[JeffersonMichJ]

I have a dataset containing the beginning and the end of a series of tasks that equipment executes. In this table, there is the name of the equipment, the task, beginning datetime, and end datetime.

I need to create a bar chart where each segment represents the total amount of minutes for a specific task for each equipment. However, I also need to insertthe free time into the chart.

Considering the following example

Equipment	Task	Start	Finish
Car 1	Deposit	12/5/2023 10:00:00	12/5/2023 11:00:00
Car 1	Withdraw	12/5/2023 12:00:00	12/5/2023 13:00:00
Car 1	Deposit	12/5/2023 13:00:00	12/5/2023 14:00:00
Car 1	Withdraw	12/5/2023 14:00:00	12/5/2023 15:00:00
Car 1	Deposit	12/5/2023 18:00:00	12/5/2023 19:00:00

Car 1 spent 3 hours depositing and 2 hours withdrawing, with a total free time on 12/05/2023 of 19 hours.

The bar chart would look something like this if the date filter was applied on 12/07/2023:

How can I do this within Power BI? Currently, I am creating fictitious "Free Time" tasks outside of Power BI for each equipment.

[Fowmy · Accepted solution]

@JeffersonMichJ 

I created three measures and visualized using the 100% Stack Bar Chart. The time difference was calculated as minutes.

Here are is the result and the file is attached below:

[JeffersonMichJ]

Thank you. That's exactly it. With this, I can also filter the first and last Start column and multiply the free time if more days are selected! Thanks.