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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

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?

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