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! Learn more

Reply
RichardMo
Frequent Visitor

Date slicer that can be reset to last 4 months only

Hi,

 

I have a date slicer, and the date range covers several years. I'd like to have a reset button that resets the slicer to show the last 4 months only. But I still want the slicer to be adjustable to include all the dates in the table.

 

I thought about using a bookmark but that would reset it to the specific dates that were set in the bookmark rather than the last 4 months up to today's date.

 

Thank you

3 REPLIES 3
Anonymous
Not applicable

@RichardMo This is exact problem I faced couple of days back but in my case I need last 14 days but in your case its Month Try with below links 

 

https://www.linkedin.com/pulse/custom-range-date-slicer-power-bi-dynamic-defaults-more-a%25C5%259F%2...

 

https://www.youtube.com/watch?v=MYHG-QSM8qw

 

I guess in any one of the link you will get solution.

If I answered your question, please mark my post as solution, Appreciate your Kudos

RichardMo
Frequent Visitor

Thank you

amitchandak
Super User
Super User

@RichardMo , As of now you need to use workaround , have a column like this and select Last 4 month and save

 

Month Type = Switch( True(),
eomonth([Date],0) > eomonth(Today(),-4) && eomonth([Date],0)<= eomonth(Today(),0),"Last 4 Months" ,
Format([Date],"MMM-YYYY")
)

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
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!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

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