Using Microsoft Gantt chart in Power BI. Slicer date to change timeline

[lacruzad]

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.

[v-menakakota]

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.

[lacruzad · Accepted solution]

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 ,

Could you please confirm if you've submitted this as an idea in the Ideas Forum? If so, sharing the link here would be helpful for other community members who may have similar feedback.

If we don’t hear back, we’ll go ahead and close this thread. For any further discussions or questions, please start a new thread in the Microsoft Fabric Community Forum  we’ll be happy to assist.

Thank you for being part of the Microsoft Fabric Community.

Best Regards, 
Menaka.
Community Support Team 

[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.

Best Regards, 
Menaka.
Community Support Team  

[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.

[lacruzad]

Hi Menaka

I really appreciate the information, but more than a solution, your response was a guidance. It's importante to differenciate that in this community. There is not a final solution in my case, just an alternative that it doesn´t satisfy the expectations and that alternative was created base in the shared information. From my point of view, it was a help and guidance, more than a solution. That's something to indicate as an option in this community.

[v-menakakota]

Hi @lacruzad ,

The information shared was more of a guide to explore options, given the current limits of the Microsoft Gantt visual.

Your workaround is a great reference for others, even if it’s not a perfect fit.

The need for the Gantt timeline to respond to slicers is clear, and with more feedback, hopefully it’s something we’ll see improved in the future. 

Thank you and Regards,
Menaka.

[lacruzad]

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.

[lacruzad]

Thanks for the response and explanation. This definitely must an improvement for any gantt visual, because it's a shame to be stuck by this limitation. Is there any way to reach my goal with a simple table, where I can see every task with start and end date for the time line? the idea is to see every tasks with different start and end date considering the duration of the task and the total amount of hours