Reply
lotus22
Helper III
Helper III

PowerBi Relative Date Filter - Crazy issue

Ran into crazy issue with the Relative date filter.

Any time I increase to anything more than last 14 weeks, I lose current data.

 

14 weeks:  I see current data: 

lotus22_0-1701802733107.png

 

However, if I increase to 15 weeks, or anything more...I keep losing recent days

 

lotus22_1-1701802796447.png

 

18 weeks:

lotus22_2-1701802821418.png

 

 

1 ACCEPTED SOLUTION
Villezekeviking
Most Valuable Professional
Most Valuable Professional

You can make use of my DAX Calendar that has offset-columns for days, weeks, months, quarters and years from today for any kind of relative date filtering!*

You'll find it here:
https://www.villezekeviking.com/dax-tables-calendar-and-time/

View solution in original post

2 REPLIES 2
Villezekeviking
Most Valuable Professional
Most Valuable Professional

You can make use of my DAX Calendar that has offset-columns for days, weeks, months, quarters and years from today for any kind of relative date filtering!*

You'll find it here:
https://www.villezekeviking.com/dax-tables-calendar-and-time/

lbendlin
Super User
Super User

That doesn't look like the standard filter pane - is this some kind of custom visual?

avatar user

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)