Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Production Time Visualization without Dates

I'm trying to come up with a visualization that shows production time over a 90 days period without using Start and End dates. I have the start and end dates but when using those in a visualization it just staggers the start date and end date (See pic below using the "as Timeline" visual) where what I'm intersted in is the pathway each product takes to completion while having the start and end normalized. 

Pic 1.PNG

 I played around with a stacked bar chart but the issue there is that some of the products go back to the same line over the course of the production pathway and the bar chart will just combine them. 

 

A simplified sample table is shown below

 

Any help would be great!

Thanks

 

NameProduction OrderTypeStart DateEnd DateProduction Days
Product X1Line 110/1/201810/7/20186
Product X2Line 410/7/201810/17/201810
Product X3Line 310/17/201810/19/20182
Product X4Line 110/19/201810/23/20184
Product X5Line 410/23/201812/29/201867
Product J1Line 210/6/201810/16/201810
Product J2Line 510/16/201810/26/201810
Product J3Line 410/26/20181/3/201969

 

1 REPLY 1
v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @Anonymous,

 

For "as Timeline" visual, Ihave no idea. However, you could try another visual.

 

You could create a Clustered bar chart like below so that some of the products go back to the same line over the course of the production pathway and the bar chart will not combine them. 

 

Untitled.png

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.