Year and Month display by default in slicer

[Umadhandapani]

Hi,

How to display current year and month to be selected in the slicer (i.e. would automatically open on the current month at all times).

[amitchandak · Accepted solution]

@Umadhandapani , There is only work around for that

Year Type = Switch( True(),
year([Date])= year(Today()),"This Year" ,
year([Date])= year(Today())-1,"Last Year" ,
Format([Date],"YYYY")
)

Month Type = Switch( True(),
month([Date])= month(Today()),"This Month" ,
month([Date]) & ""
)

or

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

Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA

You need save value like this year, this month