Passing Date Range slicer to Paginated report

[abpgupta]

Hi All,

I have slicer for date range in PBI Desktop and would like to pass it to Paginated report using DAX.

Is there any example to achieve it?

Please advise. Thanks!

[abpgupta]

 As a solution, I am passing start date and end date as separate parameters to Paginated report to make it work. 

[v-jingzhang]

@abpgupta If it only contains two parameters, it will not break the length limit. Have you tried the method in the video? Does it work?

[abpgupta]

Yes, passing as separate parameters for start and end date in DAX works fine like other filters. I was looking way to pass something like in_range function used in Cognos.

[DreamerGeek]

I am trying to pass separate start and end dates, but it keeps asking for a relationship.  How did you deal with this?

[abpgupta]

You can create DAX variable to define each of them to have selected values from parameters. Then in next variable use filter function to pass dates in filter context to get filtered results as table. This table, you can work to get final outputs.  

[v-jingzhang]

Hi @abpgupta 

I found a video (LEVEL UP Power BI Conditional Drill with Paginated reports! ) made by GuyInACube that introduces how to pass data from Power BI report to Paginated report with URL parameters. You could try this method.

In addition, how many date values are you going to pass? Because there is a length limit for URL (around 800 chars), it will probably hit the limit if it contains too many values. You could use CONCATENATEX function to combine multiple values you want to pass. There is a URL example containing a multiple-value parameter. You need to prefix the parameter name with rp: for Power BI to recognize it.

There are also some videos and blogs about passing data from Paginated report to Power BI report with URL parameters that may be helpful.

Link from a Power BI Paginated report to a Power BI report

Drillthrough from Paginated Report to Power BI 

Kindly let me know if this helps.

Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.