Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi everyone,
Is it possible to use slicer to select date as follows last day, last month, last year?
Hello @ysapiyev ,
You can have relative date slicer as :
Ping back if it's not working or this is not what you want.
Regards.
@ysapiyev,
What do you mean that buttons for day, week,year? Combine built-in date slicer and Timeline custom visual and check if you get expected result.
Regards,
Lydia
@Anonymous,
This combination doesn't work for me.
I wanted to use slicer to select current day, last week, last month or last year, and have buttons as control.
I started writing custom slicer, however I've got some problems, even though I used selection manager and iselectionid field in data, it doesn't work with dates. I implemented same technique to filter names and it worked, but not with date. What can be the problem?
@ysapiyev,
Could you please post a screenshot about your desired slicer? And could you please post a screenshot about your current problem?
Regards,
Lydia
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!