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

[apmulhearn]

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.

[GilbertQ]

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]

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