Forum Discussion
Gantt Chart visual - selecting the start date?
Hello,
I currently have a Power BI project going in which I am using the Gantt chart visual. We have a larger project list in which we have projects that started much earlier than others. My question is - is there a way to define the actual start date of the gantt chart visual that can by Dynamic and doesnt filter the actual projects themselves? If I set the start date and then apply a filter/slicer it filters out the projects that dont have a start date within the range I have selected. I would rather the start date for the visual itself change. This would help eliminate the horizontal scrolling.
10 Replies
Since the "start date" is associated with each record, when you put "start date" into column, it will definitely filter out those records without selected "start date". This is expected behavior. It's not possible to keep all records in Gantt chart and dynamically filter duration bars only.
Regards,
Hi Simon,
Can I ask why that's the expected behaviour?
I would expect at a project-level, most people would want to use the Gantt visualisation to show a specific view (e.g. the whole of 2017).
This will often include projects that started in 2016 or earlier, but because we can only filter on 'Project Start Date', these projects would dissapear if I tried to give a view of 2017.
Thank you
As you said, each project has a start date, it's just a like "tag" associated with each record. When you filter on 'Project Start Date' only, it will just filter the underlying records which match the date range you specified in slicer. So if you select Year 2017, it will not take any records in Year 2016.
Regards,
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)
