Power Up Program - Visualize data with Power BI

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:

General Discussion

data copied from ...

error data .png

I have the same question (0)

All responses (4)

Answers (0)

w.p 6,743 Super User 2025 Season 2 on at

Like (0)

Report

Relative Date Slicer Not Working on Filter Testing Page

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

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

Like (0)

Report

Relative Date Slicer Not Working on Filter Testing Page

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
CU18071313-0 8 on at

Like (0)

Report

Relative Date Slicer Not Working on Filter Testing Page

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
Suggested answer

w.p 6,743 Super User 2025 Season 2 on at

Like (0)

Report

Relative Date Slicer Not Working on Filter Testing Page

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

Community site session details

Relative Date Slicer Not Working on Filter Testing Page

Helpful resources

News and Announcements

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

Subscribe to this forum!

Select categories

Leaderboard > Microsoft Power Up Program Community

Featured topics

Product updates