Forum Discussion

bo_afk's avatar
bo_afk
Post Patron
6 years ago

Default filter for email subscription

Is it possible to apply a dynamic default filter to the report (e.g. filter for latest date), for when an email subscription is sent out?

 

I'd like the recipient to view the data for the latest date in their email, but then the ability to click through to the report and apply further filters as they wish.

Need Help

4 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    6 years ago
    Hi there

    Currently you cannot create a dynamic default filter.

    What I do is I have a Label in my report which has got the latest date for my dataset. I then pin this label to the dashboard so when it is sent out via a subscription they can view it in the email.
    • bo_afk's avatar
      bo_afk
      Post Patron
      6 years ago

      Hi GilbertQ, thanks for your response.

      Do you have an example of how you did this/how it looks like?

      • GilbertQ's avatar
        GilbertQ
        Super User
        6 years ago

        Hi there

         

        I have got a table in my dataset which only contains the Max Date

         

        I created a Card Visual, used the Max Date from above. 

        I then pinned this Card Visual to my dashboard as shown below.

         

  • v-yingjl's avatar
    v-yingjl
    Community Support
    6 years ago

    Hi bo_afk ,

    I'm afraid it is not supported in power bi service when using subcription currently.

    Please note:

    Email subscriptions are sent with the report's default filter and slicer states. Any changes to the defaults that you make after subscribing don't show up in the email. Paginated reports do support this capability and allow you to set the specific parameter values per subscription.

     

    Best Regards,
    Yingjie Li

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