setup most recent date as slicer default value

[bergen288]

I have a date slicer in last 7 days as shown below.  The date is from a dimentional table in last 7 days with 1:* relationship with my fact table.  I would like to set the most recent date as its default value (Jan 16 in this case) so that all charts/tables in this page will show information on most recent date by default.  What's the best way to address it?

Thanks.

[Anonymous]

Hi @bergen288 ,

Please set the date values of the slicer to sort in descending order. If the slicer's default date does not jump to the latest date, turn the single-select off and on again.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[bergen288]

Before today's data refresh, I tried your suggestions: Slicer date is sorted in descending order and default to Jan 16, Single selection is turned off and on.  However, slicer date is still default to Jan 16 as shown below, and all other reports in this page is stil for Jan 16 after data refresh.

[bergen288]

I checked your sample file.  The difference is that my date data is from SQL table while yours is generated by CALENDAR function.  I will try it to see if it will work or not.

[bergen288]

It doesn't work even with your sample file.  As the screenshot shown below, the default is Jan 17 while I need Jan 18 as default.