Forum Discussion

afs1313's avatar
afs1313
Regular Visitor
9 years ago
Solved

Auto Update Date Picker to Current Date

Hi All!

 

I have a Power BI report that is sitting on top of Azure SQL DB using direct query mode.  The report is embedded in web app using PowerBI Embedded.  On the report there is a date picker set to 'before', so that users can select the end date, which filters the visuals to the selected date, and all prior dates before it.

 

Is there a way for the end date to auto update to today’s date?  In other words, whenever a user opens the report, the date picker is set to the current date.  Currently, the date picker is set to whatever was saved on the pbix file.  

 

Thanks in advance for any thoughts/input!

Need Help
  • afs1313's avatar
    afs1313
    9 years ago

    Turns out this is a PEBCAK issue....

     

    I (finally) realized that the reports we had already had a date selected to filter on.  And once we saved it and uploaded to the Embedded Workspace, it was filtering (as expected) to whatever was saved.

     

    Once we recreated the slicer, and did not select a date to filter, it was showing the date of the latest data point we had (which is always today's date).  And would allow users to select any other date they wanted.

     

    Thanks

    Anonymous, Phil_Seamark, Anonymous for taking the time to reply!

  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi afs1313,

     

    Great to hear the problem got resolved! Could you accept your reply above as solution to close this thread? :smileyhappy:

     

    Regards

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    The relative date picker thing you are wanting is actually a feature currently in preview, or very soon to release. I remember reading about it.

    • Phil_Seamark's avatar
      Phil_Seamark
      Icon for Microsoft Employee rankMicrosoft Employee
      9 years ago

      Hi afs1313

       

      Yeah, as Anonymous mentioned, the new Relative Date Slicer is awsome but turn it on in your settings

       

       

      • afs1313's avatar
        afs1313
        Regular Visitor
        9 years ago

        Thanks for the replies!  I gave the Relative Date Slicer a shot, and it's a really cool feature.  I can't wait to try it out on another report.  Unfortunately, it does not satisfy the requirements I have for this report.  

         

        Users are expecting a date picker to select what the end date is for the filter, but I can't find a way (if one exists) to default whatever the end date is to the current day.  It is set to whatever was saved on the report.