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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

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 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.The Today marker is added with the =Today() function.

3 REPLIES 3
Kedar_Pande
Super User
Super User

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:

Kedar_Pande_0-1728634777648.png

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

 

Anonymous
Not applicable

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. 

StabilityTimeline2.jpg

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.

StabilityTimeline1.jpg

 

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

StabilityTimeline3.jpg

 

 

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

 

Thanks!

Dave

Anonymous
Not applicable

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. 

 

 

screenshot of excel sheet for timeline.jpg

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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