Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Set default values to slicers

Hi I have two slicers (single select), Survey Year and School. I want to set a default value for Survey Year slicer as max of the available years. and School as 'ABC', all the users logging in should see the same values max(year) and 'ABC' as filters even if they select a different one before closing the report.

 

Survey YearSchool
2010ABC
2010DEF
2010CDB
2010XYZ
2011ABC
2011DEF
2011CDB
2009XYZ

 

expectation, my slicers should always show max(SURVEY Year), School='ABC'

Thanks for the help everyone

1 Reply