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
Anonymous
Not applicable

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 

 

 

DeliveryCreation datePicking DatePacking datePGIShipment
X13/02/201813/02/201814/02/201814/02/201815/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!

 

2 ACCEPTED SOLUTIONS
Omega
Impactful Individual
Impactful Individual

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

 

StreamlineStreamlineTableTable

View solution in original post

v-juanli-msft
Community Support
Community 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

7.png 

 

Import custom visuals from Market place,

1."as Timeline"

8.png

In picture above, Turn on behavior->stack 

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

4.png

 

 

2."Gantt"

6.png

 

Please refer to my pbix

 

Best Regards

Maggie

 

 

View solution in original post

3 REPLIES 3
v-juanli-msft
Community Support
Community 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

7.png 

 

Import custom visuals from Market place,

1."as Timeline"

8.png

In picture above, Turn on behavior->stack 

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

4.png

 

 

2."Gantt"

6.png

 

Please refer to my pbix

 

Best Regards

Maggie

 

 

Anonymous
Not applicable

Thank you guys!!

Omega
Impactful Individual
Impactful Individual

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

 

StreamlineStreamlineTableTable

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.