Set customized calendar slicers to the corresponding value of today's calendar data.

[jeronimo2334]

Hello,

I have a calendar table and I am using slicers for week, month and year.
I am trying to automatically set the selected value on the slicer to the corresponding value of the current date as of today.

Any help is appreciated.

Here are the slicers and the calendar table I am using. The table has a lot more data for years bettwen 2010-2050.

id	calDate	monthName	monthShortName	weekOfMonth	fiscalYear
4565	6/25/22	July	JUL	1	2022
4566	6/26/22	July	JUL	1	2022
4567	6/27/22	July	JUL	1	2022
4568	6/28/22	July	JUL	1	2022
4569	6/29/22	July	JUL	1	2022
4570	6/30/22	July	JUL	1	2022
4571	7/1/22	July	JUL	1	2022
4572	7/2/22	July	JUL	2	2022
4573	7/3/22	July	JUL	2	2022

[amitchandak]

@jeronimo2334 , As of now this is not possible. You need use workaround

example

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

Is Today = if('Date'[Date]=TODAY(),"Today",[Date]&"")

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