Forum Discussion
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 t...
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/