Data to show by Latest date by default in Report server

[Powereports]

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"))

[V-pazhen-msft · Accepted solution]

@Powereports 

Relative filter is only based on today, you could use TOP n filter to always show the latest date on the slicer. 

You can upload your pbix to onedrive and share the link.

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[V-pazhen-msft]

@Powereports 

Your screenshot does not make sense to me, you should set the relative date filter on the visual with data not on the slicer. And to switch to other dates, you must remove the date filter then use slicer to set between range.

Regarding to Istoday, try:

Istoday = SWITCH( TRUE (), selectedvalue('Calendar'[Date]) =UTCTODAY(), "Today", FORMAT('Calendar'[Date],"MM/DD/YYYY"))

However, if you can share a sample pbix it would be more clear for me to provide better advices.

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[Powereports]

Hi ,

 Thanks for response. Can you send me your email ID to attach the Pbix.file  as i am unable to attach it here so that it gives you a clear picture?

 Curently as you can see in the screenshot below, the date is the current date , but my problem is when the report refreshes tomorrow it will include today's and tomorrow's date as well. But I want to show only tomorrow's date on the slicer and data only for the current day and not yesterday and today when the report would refresh tomorrow by default . And then if the user needs they can select the date range they want to look for.

Does it make it clear? So my actual problem is there a way that the date slicer is set to today's date and data in the visual is also set to today's date by default when report refreshes daily on the report server indicated by in the screenshot  (Last Updated on) ?