Today line in Mtrix Ghantt

[Aliwells632]

hello ive used this video -How to set a DATE SLICER to TODAY by default in Power BI to create a GHANTT chart visual. I know want the chart to open on today a default and also have a line down todays date.  Can someone help. 

[v-pgoloju]

Hi @Aliwells632,

Just a gentle reminder  has your issue been resolved? If so, we’d be grateful if you could mark the solution that worked as Accepted Solution, or feel free to share your own if you found a different fix.

This not only closes the loop on your query but also helps others in the community solve similar issues faster.

Best,

Prasanna Kumar

[v-pgoloju]

Hi @Aliwells632,

We wanted to kindly check in to see if everything is working as expected after trying the suggested solution. If there’s anything else we can assist with, please don’t hesitate to ask.

Warm regards,

Prasanna Kumar

[v-pgoloju]

Hi @Aliwells632 

Just following up to see if the solution provided was helpful in resolving your issue. Please feel free to let us know if you need any further assistance.

Best regards,

Prasanna Kumar

[v-pgoloju · Accepted solution]

Hi  @Aliwells632,

Thank you for reaching out to the Microsoft Fabric Forum Community.

To make your Gantt chart open with today's date and show a vertical line for today.

Use a relative date slicer set to "Today" or a measure that filters to TODAY() as calculated column like below measure.

IsToday = IF('Date'[Date] = TODAY(), 1, 0)

to Show today’s line on chart add a dummy task with Start and End as TODAY() to act like a vertical line.

The following links might be helpful in creating the desired solution

Solved: DAX date today query - Microsoft Fabric Community

Solved: Definitive Logic Advanced Gantt Chart - "Today" Da... - Microsoft Fabric Community

Best regards,
Prasanna Kumar