Forum Discussion
How to create a Streamline in Power BI?
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!
Try the below:
- Unpivot your dates such that you will end up with three columns: Delivery, Attribute (Creation Date, Picking Date...etc.) & Date
- Create a Line chart
- Add attribute as Legend
- Add Date as Axis
- Add Delivery Values
StreamlineTable
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
3 Replies
OmegaImpactful Individual
Try the below:
- Unpivot your dates such that you will end up with three columns: Delivery, Attribute (Creation Date, Picking Date...etc.) & Date
- Create a Line chart
- Add attribute as Legend
- Add Date as Axis
- Add Delivery Values
StreamlineTable
v-juanli-msftCommunity Support
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