How to set a default slicer value?

[Anonymous]

I have a month slicer which shows the last 13 months (by using Reletive Date in last 13 months). When a user first opens the report, I want the Month slicer to have the current month automatically selected. I also want the user to be able to select any of the other 12 months as well.

How can this be done?

[v-jayw-msft · Accepted solution]

Hi @Anonymous ,

You could use ISFILTERED() function.

If the slicer was not filtered, then show the special value, if it was filtered, show the filtered value.

Something like below.

Best Regards,

jay

[Anonymous]

@v-jayw-msft, thanks for the suggestions. I have created this measure below

SlicerMeasure1 = 

IF(ISFILTERED('dimDate'[YearMonth]), FORMAT(NOW(), "Mmm yyyy"), BLANK())

How do I use this to make the slicer automatically have Nov 2020 selected when the report opens?

[amitchandak]

@Anonymous , have a column like below in you date table and sort that on month year sort and save current month /this month on slicer

Month Type = Switch( True(),
eomonth([Date],0) = eomonth(Today(),-1),"Last Month" ,
eomonth([Date],0)= eomonth(Today(),0),"This Month" ,
Format([Date],"MMM-YYYY")
)

or

Month Type = Switch( True(),
eomonth([Date],0)= eomonth(Today(),0),"Current Month" ,
Format([Date],"MMM-YYYY")
)

refer to the video: https://www.youtube.com/watch?v=hfn05preQYA