Pre Select Slicer value based on the date

[revansh]

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

[amitchandak · Accepted solution]

@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