Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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 -

 

 

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

 

MattAllington 

Need Help

1 Reply

  • PaulDBrown's avatar
    PaulDBrown
    Community Champion
    4 years ago

    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