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!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 59 | |
| 43 | |
| 42 | |
| 23 | |
| 17 |
| User | Count |
|---|---|
| 190 | |
| 122 | |
| 96 | |
| 66 | |
| 47 |