Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Trying to replicate a horizontal timeline as a scatter plot in Power Bi

Hi,   I'm trying to re-create the Excel timeline attached in Power Bi.  I'm assembling timelines for stability studies for around 40 lots of 5 different molecule types. I'm hoping to re-generate th...
Interesting Links
Need Help
Kedar_Pande's avatar
Kedar_Pande
Icon for Super User rankSuper User
1 year ago

Ensure your data includes columns for:
Molecule type
Lot number
Event description (e.g., "3M 5°/80C")
Event date (specific date when the event occurs)

Create date table:

DateTable = DATEDIFF(MIN(DateTable[Date]), DateTable[Date], DAY)

In Power BI, use the below visual from app store:

If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

This is helpful and I think I'm getting closer. I have two examples of what I'm getting as an output, but neither is as readable as the excel chart.  I attached the outputs I'm getting from the x/y scatter and the Queryon timeline. 

The Timeline thing is assigning non-existent dates to things and bunching my datapoints. 

 

The x/y scatter is doing better but I'm still not getting the right information into each of the data points.  I have a date file with the serial date to match the X-value in the table with the milestone text data.

 

The excel screenshot is the raw data for what is being displayed. 

 

 

Any guidance would be appreciated and thank you for helping me get this far 🙂

 

Thanks!

Dave