Forum Discussion
Using Microsoft Gantt chart in Power BI. Slicer date to change timeline
Using Microsoft Gantt chart in Power BI. `Actividad_Visible` filters tasks based on a slicer (`Calendar[Slicer_Date]`, today to 2030) using `[Start_Date_Selected]` and `[End_Date_Selected]`. Tasks (990 hours, ~6 months) use DAX-calculated `Start_Date_Sequential` and `End_Date_Sequential` (sequenced by `ID_Question` and `Index`). Tasks are sequential, but the timeline ignores the slicer, showing the full task date range. Initially, the timeline matched the slicer. Tried visual filters and clipped dates. Is there a simple Gantt setting or DAX tweak to align the timeline with the slicer range? No complex tables or visuals.
I found a way to build a gantt chart with a time line of the task in sequetial way, excluding the slicer. It was a combination of custom columns in my main table and DAXs.
Regards
10 Replies
v-menakakotaCommunity Support
Hi lacruzad ,
Just to clarify, are you looking to filter only the visible tasks based on the slicer, or are you also trying to limit the entire Gantt chart timeline (date axis) to match the slicer range?
Thank you.Hi v-menakakota
Thanks for your response, the idea is to show the selected timeline from the slicer in the gantt chart. If I select from the slicer a start date and an end date, that range it should update the gantt chart and show the tasks in that range, so yes, the goal is that the gantt chart timeline matches with the slicer range.
- v-menakakota
Hi lacruzad ,
Thank you for reaching out to us on the Microsoft Fabric Community Forum.
We really appreciate your efforts and for letting us know the update on the issue, the Microsoft Gantt chart (from AppSource) does support filtering tasks using slicers, but unfortunately it doesn’t dynamically adjust the timeline axis (x-axis) based on slicer selections. This means that even when the task list is filtered, the visible date range in the chart remains unchanged.If this functionality is important to your scenario (which makes a lot of sense, especially for focused reporting), I’d strongly recommend posting it to the Power BI Ideas forum here:
Ideas Forum
That’s the best way to get visibility from the product team and allow others to vote on it. Many features in Power BI have come directly from user suggestions like this.
If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.
I found a way to build a gantt chart with a time line of the task in sequetial way, excluding the slicer. It was a combination of custom columns in my main table and DAXs.
Regards
- v-menakakota
Hi lacruzad ,
We really appreciate your efforts and for letting us know the update on the issue.
Please continue using fabric community forum for your further assistance.
If this is the solution that has worked for you please accept your reply as solution so as to help other community members who may face similar issue in the future
Thank you and Regards,
Menaka.