paginated reports - how do you insert a start & end date into paginated reports from the BI report?

[StevenT]

How do you pass a user start and end date into a paginated report from your power BI report?
From my calendar[date] field, A user can choose a start and end range.

The trouble is that no matter what range I choose in the slicer it always shows the earliest and latest calendar dates.
when i choose a different range in the slicer, it still gives me the same date range. Both of these are columns with the formulas
MIN(Calendar[Date]) and MAX(Calendar[Date])

How do i pass the actual MIN and MAX dates that the user chooses?

[v-pnaroju-msft]

Hi StevenT,

We would like to follow up and see whether the details we shared have resolved your problem. If you need any more assistance, please feel free to connect with the Microsoft Fabric community.

Thank you.

[v-pnaroju-msft · Accepted solution]

Hi StevenT,

Thank you for contacting the Microsoft Fabric Community Forum.

Based on my understanding, the issue occurs because MIN and MAX were created as calculated columns. Calculated columns always return the earliest and latest dates present in the model and do not respond to slicer selections.

Please follow the approach below which might help to resolve the issue:

1. Create dynamic measures as follows:

   SelectedStartDate = CALCULATE(MIN('Calendar'[Date]), ALLSELECTED('Calendar'))
   SelectedEndDate = CALCULATE(MAX('Calendar'[Date]), ALLSELECTED('Calendar'))

2. Pass these measures into the paginated report using the Paginated Report visual. Map Calendar[Date] to the Start and End parameters with Min/Max aggregation and enable Auto apply filters. In Report Builder, ensure that the parameters are defined as Date/Time. This will ensure that the slicer selected date range is passed correctly.

Additionally, please refer to the links provided below for further details:
Create and use the paginated report visual - Power BI | Microsoft Learn
Create parameters for paginated reports in Power BI Report Builder - Power BI | Microsoft Learn
Report parameters in Power BI Report Builder - Power BI | Microsoft Learn

We hope this information helps resolve the issue. If you have any further queries, please feel free to contact the Microsoft Fabric Community.

Thank you.