cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

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!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors