Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreWe've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
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.
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
| Name | Production Order | Type | Start Date | End Date | Production Days |
| Product X | 1 | Line 1 | 10/1/2018 | 10/7/2018 | 6 |
| Product X | 2 | Line 4 | 10/7/2018 | 10/17/2018 | 10 |
| Product X | 3 | Line 3 | 10/17/2018 | 10/19/2018 | 2 |
| Product X | 4 | Line 1 | 10/19/2018 | 10/23/2018 | 4 |
| Product X | 5 | Line 4 | 10/23/2018 | 12/29/2018 | 67 |
| Product J | 1 | Line 2 | 10/6/2018 | 10/16/2018 | 10 |
| Product J | 2 | Line 5 | 10/16/2018 | 10/26/2018 | 10 |
| Product J | 3 | Line 4 | 10/26/2018 | 1/3/2019 | 69 |
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.
Best Regards,
Cherry
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 51 | |
| 37 | |
| 35 | |
| 19 | |
| 17 |
| User | Count |
|---|---|
| 70 | |
| 65 | |
| 39 | |
| 33 | |
| 23 |