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!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
Hi,
I have created a date slicer that defaults to the date range of my date table; however I want to be able to start the start date to the beginning of a month ago (or 30 days ago) and my to date to be out 180 days.
Does anyone have any suggestions/links on this?
What you want is not a dynamic date slicer but a static date slicer - you want the dates to always be governed by the same calculation. I believe there are a couple of open ideas for this feature - go vote for them.
Do you actually need the date slicer? You can calculate your date range in a calculated column, for example you can add a flag into your dates/calendar table that identifies the dates you want included. And then you can use that flag to drive the slicer, or the actual data display filter.
Vote for your favorite vizzies from the Power BI World Championship submissions!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 2 | |
| 1 | |
| 1 |