Forum Discussion

apmulhearn's avatar
apmulhearn
Icon for Helper III rankHelper III
3 years ago

Create Relative Date Parameter in Power BI Report Builder (Paginated Report)

Hello,

 

I am trying to create a paginated report in Power BI Report Builder which will allow me to extract records for a relative date parameter (the last calendar week; the last 30 days; etc).

 

I'm stuck! I have it working beautifully in a PowerBI Desktop model, but often, it requires scrolling, so I need a weekly paginated report.

 

Any guidance will be greatly appreciated. Thank you.

 

 

 

 

Need Help
Tutorial Requests

2 Replies

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    3 years ago

    Hi apmulhearn 

     

    What I would suggest doing is to create dataset which takes the parameters for the different weeks and then use that as the parameter field.

    • apmulhearn's avatar
      apmulhearn
      Icon for Helper III rankHelper III
      3 years ago

      Hi GilbertQ  - I appreciate the suggestion, but I don't think I follow. Do you have an example you could point me to?

      My date table does have a 'week end date' field and a 'week number' field, if either of those is helpful.

      Thank you