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

[Anonymous]

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 this timeline with slicers for each molecule and lot number to display the stability timeline for that particular project.  I have a date table in PowerBi but it doesn't include the serial date and I'm thinking that might be a way to go, but I wanted to get some advice. 

Thanks!

DaveThe Today marker is added with the =Today() function.

[Kedar_Pande]

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]

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

[Anonymous]

I should add that I'm not able to get the date range to display properly in PowerBi.  The spreadsheet I used is below and I used the Data Label to get the spacing for the labels and then assigned the data labels from a column with concatenated data.