Creating a project Timeline using a Line Chart

[Walt1010]

Noob here. I'm creating a timeline to track the position of properties that are undergoing refurbishment. At the most basic, I'd like to show the first date each property was empty, the target date the property is being re-let, and the current date somewhere along the timeline between those dates.  I can create the straight line with a constant measure, but how do you put something (a shape or a vertical line) through that constant line? I have the start and end dates. I've tried dragging various dates onto the X-axis, but I haven't had any success. Ideas please!

[Anonymous]

Hi All,
Firstly  lbendlin thank you for your solution!
And @Walt1010 ,I tried to use gantt visual objects to do what you need and I hope my approach is helpful! 

Progress = 
VAR StartDate=MIN('Table'[Empty Date])
VAR EndDate=MAX('Table'[Target Date])
VAR TodayDate=TODAY()
RETURN
IF(
    TodayDate>=StartDate&&TodayDate<=EndDate,
    DIVIDE(DATEDIFF(StartDate,TodayDate,DAY),DATEDIFF(StartDate,EndDate,DAY)
    ,
    0
    ),
    IF(TodayDate>EndDate,1,0)
)

If you have any other questions, check out the pbix file I uploaded, I hope it helps!

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

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

[lbendlin]

Are you looking for a Gantt chart or a barbell chart type?

(There's always Deneb if you are willing to invest some time)

[Walt1010]

Probably more barbell than gantt. I'll take a look at deneb too.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...