Showing results for 
Search instead for 
Did you mean: 
Advocate I
Advocate I

Dynamic slicer default date range

Hi all,


I have a date slicer for which I'd like the last 13 months to be selected by default, but still having all other months from other years available for selection to give users the option to select data outside of the last 13 months. I want this to be dynamic so that the default values selected in the filter changes as time progresses. 


For example as it is currently Feb 2022, I'd like the default values selected to be from Feb 2021 - Feb 2022. When it comes to March 2022 this would dynamically change to have default values selected as March 2021 - March 2022 and so on.

Typical date hierarchy (Year, Month, Day)



I've been trying to find solutions but have had no luck. Is this possible?

Thank you

Super User
Super User


I am not sure of what you want but try this

Flex a Pivot Table to show data for x months ended a certain user defined month.

Ashish Mathur
Super User
Super User

You could use the Relative Date slicer option if that works for you.

It is a shame that we still can't default these.

You may be able to do something with bookmarks to default it on refresh/button click but it would likely be very complex.




Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.
Proud to be a Super User!PBI-Super-User-Rank-30x30-1x
Advocate I
Advocate I

Hi, thank you for for advising. 

Not quite what I'm after but if it's the closest solution then I may have to go with it.

Super User
Super User

@MBPCCX , It is not possible to default like this.

The only thing that you can create a slicer using a column like this


Month Type = Switch( True(),
eomonth([Date],0) <= eomonth(Today(),0) && eomonth([Date],0) >= eomonth(Today(),-12),"Last 13 Month" ,


You can log an idea too -

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors