Relative Date Slicer Not Working on Filter Testing Page

(0) Share

Report

Posted on by CU18071313-0

Hi,

I’m having an issue with filter testing page where a relative date slicer causes this error: "Error fetching data for this visual. An unexpected error occurred (file '', line , function ''). When applying filters like Last 3 Months.

"What I’ve done Relationship is active: Loans[Date Loan Start] → dimDate[Date] (many-to-one). - Dates exist in both tables and match- Tried multiple anchor dates (01/01/2024, today’s date, etc.) — same error.Visual loads fine without the slicer - No filters are blocking the data.

Any idea why the slicer breaks the visual even though the setup looks correct?

Thanks!

Categories:

Miscellaneous

data copied from ...

error data .png

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

w.p 8,339 Super User 2025 Season 2 on at

Like (0)

Report

There is a known issue, due to the different date type between dateLoanStart column (Date/Time) in Loan table and Date column (Date) in dimDate table.

Simply, you need to change data type of the dateLoanStart column to Date only in Power Query.

A greate detail posted here: https://community.powerplatform.com/forums/thread/details/?threadid=76cce9c4-0e48-4b46-a05b-af3924abcd76

If the issue persists after you've made the fix, please share the visual table settings so we can take a closer look.

Was this reply helpful? Yes No
CU18071313-0 17 on at

Like (0)

Report

Hi,
Thanks for the suggestion. I’ve updated the dateLoanStart column to Date type in Power Query as advised, but the issue with the Relative Date slicer on the Filter Testing Page is still persisting.Attached are the screenshots of the issue, including the loan data . Let me know if there's anything specific you'd like me to share or double-check.

Appreciate your support!

data before apply...

error data .png

loans data.png

Was this reply helpful? Yes No
w.p 8,339 Super User 2025 Season 2 on at

Like (0)

Report

I'm not entirely sure—could you please try creating a brand-new blank file from scratch? That might help to determine if it's just a settings issue.
If possible, sharing the BI file would make things easier and quicker to troubleshoot.

Was this reply helpful? Yes No
w.p 8,339 Super User 2025 Season 2 on at

Like (0)

Report

Hi, Just following up on this, if you have any more queries, or has it been resolved?

Was this reply helpful? Yes No

Join the conversation

Community site session details

Relative Date Slicer Not Working on Filter Testing Page

Helpful resources

News and Announcements

Quick Links

Forum hierarchy changes are complete!

Ajay Kumar Gannamaneni – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Microsoft Power Up Program Community

Featured topics

Product updates

Community site session details

Relative Date Slicer Not Working on Filter Testing Page

Helpful resources

News and Announcements

Quick Links

Forum hierarchy changes are complete!

Ajay Kumar Gannamaneni – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Microsoft Power Up Program Community

Featured topics

Product updates