Forum Discussion

bergen288's avatar
bergen288
Icon for Helper IV rankHelper IV
3 years ago

setup most recent date as slicer default value

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.

 

 

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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's avatar
      bergen288
      Icon for Helper IV rankHelper IV
      3 years ago

      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's avatar
        bergen288
        Icon for Helper IV rankHelper IV
        3 years ago

        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.