Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
MBPCCX
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)

MBPCCX_0-1645667437983.png

 

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

Thank you

4 REPLIES 4
Ashish_Mathur
Super User
Super User

Hi,

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
KNP
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.

 

KNP_0-1645748171016.gif

 

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 ;).
chrome-9xf-Zagzel-B

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.
KIfp67uy-Sr
Proud to be a Super User!PBI-Super-User-Rank-30x30-1x
MBPCCX
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.

amitchandak
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" ,
Format([Date],"MMM-YYYY")
)

 

You can log an idea too -https://ideas.powerbi.com/ideas/

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.