Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
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
@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.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
Thank you
@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")
)
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.