Timeline/Schedule Milestone Comparison

Hi CCI_Dev 

Based on your description, i create a visual use scatter plot in Power BI, you can refer it.

Sample data 

1.Create two calculated columns in table.

Rank = RANKX('Table',[Date],,ASC)

UpdateType = [Update]&" "&[Type]

Then select the UpdateType column and select sort by rank column

2.Create a measure 

Measure = 1

Then put the date to x-axis, put the measure to y-axis, and put the UpdateType column to legend.

Then you can set the mark in properities.

Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi CCI_Dev 

If you want to achieve this, you can create the following field that the update field is blank, but the date field is not, you can refer to the following picture.

Then modifty the measure to the following

Measure = IF(MAX('Table'[Update])=BLANK(),-1,1)

Then set the min and max value of the y-axis.

Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.