Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi All,
I am building a gantt chart to show schedule of skills assigned to different employees. So I have included Start Date and End Date on x-axis.
In the screenshot below, x-axis in gantt chart starts with Apr 2021(minimum Start Date) without any selection.
But When I select value from slicer, x-axis changes (starts with Jul 2021) and x-axis starts with minimum Start date of selected data.
I want the gantt chart to get filtered but x-axis should remain the same.
Please suggest how I can fix/lock the x-axis (showed in first screenshot) that doesn't chnage with selection.
Here is the link of pbix file:
https://drive.google.com/file/d/1J4bI07jNHkrXlEve63z5O7KG44VuluDY/view?usp=sharing
Thanks
I want the gantt chart to get filttered but x-axis should remain the same.
Hi, @Anonymous
The start date for HANA is 1st of July according to your data, then when you select it is starting on that date.
Would you clarify what you want as output on your gantt chart?
Proud to be a Super User!
Try to disable interaction between slicer and gantt chart.
Click on slicer then in gantt chart header click on icon to block it
Proud to be a Super User!