How to create a Streamline in Power BI?

[Anonymous]

Hi guys!

On a visualization level, how can I create a streamline in Power bi? Basically I have some dates that I want to show people to track the status of one delivery. So for example 

Delivery	Creation date	Picking Date	Packing date	PGI	Shipment
X	13/02/2018	13/02/2018	14/02/2018	14/02/2018	15/02/2018

I have it actually exactly like this, as a table in my report but I want to make it visually better, Any recommendation?

Thanks!

[Omega · Accepted solution]

Try the below: 

1. Unpivot your dates such that you will end up with three columns: Delivery, Attribute (Creation Date, Picking Date...etc.) & Date
2. Create a Line chart
3. Add attribute as Legend
4. Add Date as Axis
5. Add Delivery Values

StreamlineTable

[v-juanli-msft · Accepted solution]

Hi @Anonymous

Based on my test, there are two custom visuals you may try.

In Editor Queries, select columns from "Creation date" to "Shipment", then go to "Transform"->Unpivot columns

 

Import custom visuals from Market place,

1."as Timeline"

In picture above, Turn on behavior->stack 

If you turn off behavior->stack, it will show as below

2."Gantt"

Please refer to my pbix

Best Regards

Maggie

[Anonymous]

Thank you guys!!

[Omega · Accepted solution]

Try the below: 

1. Unpivot your dates such that you will end up with three columns: Delivery, Attribute (Creation Date, Picking Date...etc.) & Date
2. Create a Line chart
3. Add attribute as Legend
4. Add Date as Axis
5. Add Delivery Values

StreamlineTable