Forum Discussion

MBPCCX's avatar
MBPCCX
Icon for Advocate I rankAdvocate I
4 years ago

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...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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/