Forum Discussion

jhastings94's avatar
jhastings94
New Member
3 years ago

Report not loading Today's date as default

Good afternoon, 

 

I hope you are able to offer some assistance. 

 

I have a report with a date slicer. The requirement for this slicer is for it to be a 'Between' Slicer with the slider included along the bottom as well as the calendar dropdown.  As such, this slicer will need to be of the data type 'Date'. There is currently a relative date filter on the slicer to get all dates loaded from a Dim_Date table up to, and including, Today(). This report also has the current option selected: 'Don't allow end user to save filters on this report.'

 

It seems that if we are to upload the the report as of today 30/05/2023, and open the report tomorrow, the date within the slicer will load on 30/05/2023 rather than what we would require, that it will load through with 31/05/2023. 

 

Is there a way to have the date slicer default to the current date. We have discussed having the option "Today" with the client in the form of a calculated column similar to the below:

 

Date Slicer = IF([Date] = TODAY(),"Today", IF([Date] < TODAY(), [Date] & ""))
 

Although they do require the calendar dropdown option, so we are unable to use this method.

 

Hope you are able to assist or provide more understanding to this issue.

 

TLDR: Date Slicer doesn't default to the current day onLoad of the report in the service. 

 

Many thanks

Need Help

1 Reply

  • ibarrau's avatar
    ibarrau
    Super User
    3 years ago

    Hi. The calculated columns like the PowerQuery transformations will only solve once when the dataset is refreshed. It doesn't matter it says TODAY because that will be resolved when the dataset is refreshed. You might want to refresh the dataset at 1am to keep the date updated for the day you are openning the report. That way TODAY function will show current date before any person open the report when they start working.

    I hope that helps,

    P/D if you want preselected slicers, you can look for the custom visual "Preselected Slicer". Maybe thatone will help