Visual for data having sequential events

[Anonymous]

Hello,

I have data with following structure -

primary_key	task_name	task_start_time	task_duration (hr)
123456	purchasing	10-03-2021 12:08:56	8
123456	storing	10-03-2021 20:08:56	24
123456	using	11-03-2021 20:08:56	12
123456	recycling	12-03-2021 08:08:56	2
123456	discarding	12-03-2021 10:08:56	2
7890	purchasing	11-03-2021 16:06:34	24
7890	using	12-03-2021 16:06:34	4
7890	discarding	12-03-2021 20:06:34	3

Based upon the data, I want to create a visual in Power BI that will give me the sequential information about the tasks. 

Requirement : Select a single "primary_key" in the slicer and you should see something like this -

Could you please suggest if there is any other way of showcasing this sequential flow of events in Power BI?

@MattAllington 

[PaulDBrown]

See if this works.

Create a measure for each step with the equivalent to the following:

Duration = 
SUM('Table'[task_duration (hr)])

Purchasing =
"Purchasing Duration" & UNICHAR ( 10 ) & "="
    & CALCULATE ( [Duration], 'Table'[task_name] = "Purchasing" ) & " hrs"

Create the visual by inserting the arrow shaped object under Insert / Shapes in the ribbon

Add a card visual overlaying each arrow with it's corresponding measure. Add the slicer and you get:

I've attached the sample PBIX file