Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

Visual for data having sequential events



I have data with following structure -

primary_keytask_nametask_start_timetask_duration (hr)
123456purchasing10-03-2021 12:08:568
123456storing10-03-2021 20:08:5624
123456using11-03-2021 20:08:5612
123456recycling12-03-2021 08:08:562
123456discarding12-03-2021 10:08:562
7890purchasing11-03-2021 16:06:3424
7890using12-03-2021 16:06:344
7890discarding12-03-2021 20:06:343


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?



Community Champion
Community Champion

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

Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.

Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.