Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
Anonymous
Not applicable

X-axis changes with Selection

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.

Meenakshi_Kaus_0-1642413219238.png

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. 

Meenakshi_Kaus_1-1642413412508.png

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

 

4 REPLIES 4
Anonymous
Not applicable

@ALLUREAN 

I want the gantt chart to get filttered but x-axis should remain the same. 

ALLUREAN
Solution Sage
Solution Sage

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?




Did I answer your question? Mark my post as a solution!


https://allure-analytics.com/
https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA
https://www.linkedin.com/company/77757292/

Proud to be a Super User!




Anonymous
Not applicable

Hi @ALLUREAN  

x-axis should remain the same (as shown below) and should not chnage with selection

Meenakshi_Kaus_0-1642418036747.png

 

 

Try to disable interaction between slicer and gantt chart.

1.PNG

Click on slicer then in gantt chart header click on icon to block it




Did I answer your question? Mark my post as a solution!


https://allure-analytics.com/
https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA
https://www.linkedin.com/company/77757292/

Proud to be a Super User!




Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors