Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Daily report - Display yesterday's data, but enable dynamic date filter

Hello,

 

I'm designing a daily report displaying data from yesterday. I had this solved by applying a relative date filter in the page level.

 

Now I would like to give users the possibility to look at former days (individually, meaning just 1 day data) in the same report. In my head, adding a calendar slicer (by the way I couldn't find any for just 1 date, all of the work in ranges) that alters the page level filter will be great, but I couldn't find the way...

 

Another possibility will be to have a date slicer / picker where you can set 'yesterday' as default, but neither I've found a visual capable of this.

 

Does anybody have any idea how to solve this? Thanks!

Need Help

13 Replies

  • BeemsC's avatar
    BeemsC
    Icon for Resolver III rankResolver III
    8 years ago

    Im pretty sure the slicer supports relative date filtering.
    Try to look for it in the drop down after adding your data

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Dear Anonymous,

     

    You can try Relative Date Slicer.

     

    Or tell more about your needs, include a sample picture result that you want.

     

    Regards,

    ManNVSM.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi,

     

    What I would like to have is data displayed for yesterday (that it's not necessary the last day, there could be data "in the future") by default, when the report is opened, and a slicer / calendar that allows me to go back to a certain day to see the data.

     

    Thanks.

    • BeemsC's avatar
      BeemsC
      Icon for Resolver III rankResolver III
      8 years ago

      Hey,

      Just try it ...
      Last 1 day means yesterday

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Hi BeemsC,

        No, it doesn't mean yesterday in this case... Last 1 day for a slicer equals to last day with data -1.

        If you use report / page / visual filtering using date, you can set "is in the last 1 days" and deativate "Include Today" to have yesterday's, but not in the slicer.

        In my case some data is carried over automatically, I've got data until tomorrow 24th November, so date displayed if I try "Last 1 day" is 23th November.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Dear Anonymous,

       

      I'm still unclear your request. Can you give me your example by picture, or something like pbix file please?

      I need to know more about your slicer/trend/ table data,...

       

      Regards,

      ManNVSM.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Hi Anonymous,

         

        Due to the nature of the data I'm not allowed to share screenshots or pbix files, but I'm attaching a very basic "blueprint".

         

         

        When you open the report, by default is should display yesterday's date (and data). Using a calendar / slicer, give the user the opportunity to change the date, overriding the default date.

         

        I hope this clarifies my request. Thanks for your help.

  • Nithyakala's avatar
    Nithyakala
    Frequent Visitor
    8 years ago

    For me also have same requirement ? any body have an idea for this?

    • haditabani's avatar
      haditabani
      Frequent Visitor
      8 years ago

      Has anyone found a solution to this problem?