Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
I have 2 slicers (Year month in French) + and Start week .
"Start and End of the month "defined by acccounting so for example first week of February starts on 2021/01/31....
I want on each opening of report set Month Year slicer to Max Value -1 (in March 2021 ,it should be February 2021) and Week start slicer to Last week of February (2021/02/21 )
Leaving user option to change Month Year and Week start later
Thank you
Solved! Go to Solution.
@Alex_G7 , You have create column like
Month Type = Switch( True(),
eomonth([Date],0) = eomonth(Today(),-1),"Last Month" ,
eomonth([Date],0)= eomonth(Today(),0),"This Month" ,
Format([Date],"MMM-YYYY")
)
and select last month, same way you have create for max week of last month and select that.
New column "Month Type" will have following presenation in "single selection" Slicer
"This Month"
"Last Month"
January 2021
December 2020
How to make sure that on opening of the report on slicer with "single selection"
"Last Month" will be already selected AND when client choose to use "drop down" all values bellow
will be listed in order to change selection
--------------
"This Month"
"Last Month"
January 2021
December 2020
Thank you
@Alex_G7 , You have create column like
Month Type = Switch( True(),
eomonth([Date],0) = eomonth(Today(),-1),"Last Month" ,
eomonth([Date],0)= eomonth(Today(),0),"This Month" ,
Format([Date],"MMM-YYYY")
)
and select last month, same way you have create for max week of last month and select that.