Forum Discussion
Today line in Mtrix Ghantt
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.
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 solutionSolved: DAX date today query - Microsoft Fabric Community
Solved: Definitive Logic Advanced Gantt Chart - "Today" Da... - Microsoft Fabric Community
Best regards,
Prasanna Kumar
4 Replies
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 solutionSolved: DAX date today query - Microsoft Fabric Community
Solved: Definitive Logic Advanced Gantt Chart - "Today" Da... - Microsoft Fabric Community
Best regards,
Prasanna KumarHi 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
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
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