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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount 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.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors