Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

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



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.







Super User
Super User

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.

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Power BI Blog

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


Helpful resources

Vote for T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Vote for your favorite t-shirt design now through March 28.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

March Events 2023A

March 2023 Events

Find out more about the online and in person events happening in March!

Top Solution Authors