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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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/

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.