Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

SET Report Default Load to Academic Year

I have a startDate column and I have created a slicer in my using the startdate as seen below     What I would like to archieve is to set my Slicer report default load academic year. i.e 1st...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    thank you amitchandak  and edhans  I had below worked and use it as a page filter which default my report load to current academic year and its dynamic, I thought there might be a better way without using it on a page filter .

     

    CurrentAcademicYear = (IF(MONTH([StartDate])>=9,YEAR([StartDate]),YEAR([StartDate])-1)&"/"&(IF(MONTH([StartDate])>=9,YEAR([StartDate]),YEAR([StartDate])-1))+1) =(IF(MONTH(TODAY())>=9,YEAR(TODAY()),YEAR(TODAY())-1)&"/"&(IF(MONTH(TODAY())>=9,YEAR(TODAY()),YEAR(TODAY())-1))+1)
     
    thanks for your help
edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
6 years ago

Cannot be done. Unfortunately, you cannot set a slicer default after the report is published. So if you publish today with Sept 2020 as the default, it will always be that unless you choose anohter default next year for the 2021 year.

 

Vote for this here. It is a very popular request.