Forum Discussion
Gantt Chart visual - selecting the start date?
Hi
I have the exact same problem as justincooper88. My Gantt chart is showing projects and project periods.
I would like the Gantt chart view to show a specific period e.g. September. Because i use the start date in the slicer, it filters out any projects that has a start date before 1st of september, even though the projects run through september.
Has anyone found a solution for this?
Think I found a solution on the date range issue.
Add a "Date range" custom column to extract all dates between start and finish date:
Date Range = {Number.From([Deployment Start Date])..Number.From([Deployment Finish Date])}
Use this field in the gantt and select earliest in the start date field and latest in the end date field.
Insert a slicer on the Date range field and all projects having a date within the range will appear, but only with a bar appearing within the selected date range.
Were you able to get that to work in the MS Gantt visual AnnesofieS? I can only get it work in the other Gantt on the store. (Can't get Earliest to show against the Start Date field)
