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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Diego_IR
Regular Visitor

X-axis filtering with a slicer

Hi !

I'm trying to filter a Combo Chart with a "Between" Slicer. In one report it's working ok, this is, adapting the period of time in the x axis to the selected period in the slicer. But on the other report is not working. Instead it's filtering the graph, but not the x axis.

The model has a Calendar Lookup with a Start of Month column that connects to the F

 

I already checked:

 

  • Relationsips in model
  • Ensured formate is "date" for Start of Month Column
  • Eliminated slicer and graph and re generated to check for glitches
  • Checked for interacions (Format, edit interactions)
  • I read about chaging the X axis from Categorical to Continuos  or the X axis range. But it looks like those options are not available anymore on PowerBi 2025 version

Below there's photos of before, and after appplying the filter

 

Thanks in advance!

 

 

 

Working - before slicerWorking - before slicerWorking - after slicerWorking - after slicerNot working - before slicerNot working - before slicerNot working - after slicerNot working - after slicer

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @Diego_IR,

Thanks for reaching out to the Microsoft fabric community forum.

From what you've described, it looks like the slicer is filtering your data correctly but not updating the X-axis range on one of your combo charts. Since it's working in another report, we can rule out some broader model-level issues and focus on visual-level configurations.

Given that relationships are in place and you're using a proper date field and have checked interactions. And you also confirmed that you're on the latest 2025 version where categorical/continuous axis settings seem to be missing. 

 

As you are still unable to solve the issue even after going through the trouble-shooting steps, you can reach out to Microsoft Support by raising a ticket with Microsoft Support.

Please refer below link on how to raise a contact support or support ticket.
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

 

I would also take a moment to thank @Ashish_Mathur, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

 

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Best Regards,
Hammad.
Community Support Team

 

If this post helps then please mark it as a solution, so that other members find it more quickly.

Thank you.

View solution in original post

6 REPLIES 6
Anonymous
Not applicable

Hi @Diego_IR,

Thanks for reaching out to the Microsoft fabric community forum.

From what you've described, it looks like the slicer is filtering your data correctly but not updating the X-axis range on one of your combo charts. Since it's working in another report, we can rule out some broader model-level issues and focus on visual-level configurations.

Given that relationships are in place and you're using a proper date field and have checked interactions. And you also confirmed that you're on the latest 2025 version where categorical/continuous axis settings seem to be missing. 

 

As you are still unable to solve the issue even after going through the trouble-shooting steps, you can reach out to Microsoft Support by raising a ticket with Microsoft Support.

Please refer below link on how to raise a contact support or support ticket.
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

 

I would also take a moment to thank @Ashish_Mathur, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

 

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Best Regards,
Hammad.
Community Support Team

 

If this post helps then please mark it as a solution, so that other members find it more quickly.

Thank you.

I ended up fixing it!

The problem was that yellow line that has values of 0 for the months out of the slicer selection. I had to enclose my measure in brackets an validate for zeros.

 

 

PrevMonth EAC Accum. =
VAR Function =
    CALCULATE(
        [PrevMonth EAC],
            DATESINPERIOD(
            'Calendar Lookup'[Start of Month],
            MAX('Calendar Lookup'[Start of Month]),
            -[ProjectDuration],
            MONTH)
   
    )
RETURN
    IF (Function > 0,
        Function,
        BLANK()
    )
Anonymous
Not applicable

Hi @Diego_IR,

As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or were you able to raise the support ticket for the issue with Microsoft Support Team.

If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.


If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.

Anonymous
Not applicable

Hi @Diego_IR,

We are following up once again regarding your query. Could you please confirm if the issue has been resolved through the support ticket with Microsoft?

If the issue has been resolved, we kindly request you to share the resolution or key insights here to help others in the community. If we don’t hear back, we’ll go ahead and close this thread.

Should you need further assistance in the future, we encourage you to reach out via the Microsoft Fabric Community Forum and create a new thread. We’ll be happy to help.

 

Thank you for your understanding and participation.

Ashish_Mathur
Super User
Super User

Hi,

Share the download link of the PBI file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Hi Ashish,

 

I can't sorry. Privacy issues due to work.

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

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