Forum Discussion
Pre Select Slicer value based on the date
Hi
I have 2 slicers on my report page.
Slicer 1: Date Field
Slicer 2: Quarter ( Q1 , Q2, Q3,Q4 starting from JAN to DEC).
if a user opens the report on 10-jun-2022 , I want Slicer2 to be pre selected as Q2 . I saw some blogs defauting the slicer.
But in our case, we want to pre select the filter value along with other values.
Thanks
revansh , As of Now , there are work around like, having a column like this and select This Qtr and save
Switch( True() ,
format(today(), "YYYY - \QQ") = [Qtr Year] , "This Qtr",
[Qtr Year]
)
Please make sure you match the format with Qtr Year
1 Reply
revansh , As of Now , there are work around like, having a column like this and select This Qtr and save
Switch( True() ,
format(today(), "YYYY - \QQ") = [Qtr Year] , "This Qtr",
[Qtr Year]
)
Please make sure you match the format with Qtr Year