Data to show by Latest date by default in Report server
Hi Users, I am able to show the report by latest date using the relative filtering option but i have a problem when the data refreshes on the report server on a daily schedule. Currently when the data refreshes on the report server using the schedule refresh the Date slicer fails to show the latest date by default. So now every time i have to refresh the report on desktop and upload the latest version to server. So my question is there a way where the date is defaulted to current date every time report refreshes in the date slicer as below by default? And then the user can customize the time period they would need . Also, i created a Istoday column to achieve this as below but it seems that when i use that column it doesnot give the between option to select date range and just gives the List and Dropdown option, so could not use this column. Istoday = SWITCH( TRUE (), 'Calendar'[Date] =UTCTODAY(), "Today", FORMAT('Calendar'[Date],"MM/DD/YYYY"))
