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_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...
Need Help
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