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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
thedipeshpuri
Frequent Visitor

Visual for data having sequential events

Hello,

 

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 -

 

thedipeshpuri_1-1647529979451.png

 

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

 

@MattAllington 

1 REPLY 1
PaulDBrown
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:
Progression.gif

 

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

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.