Paginated Report Not Showing End Year from Date Slicer

[Vishruti]

Hello,

I am generating paginated excel report through a DAX on Desktop report.

I have a 'between' Year slicer as a filter added where the user can select start year and end year for filtering records.

What I have observed is that, the exported paginated report is not showing any records of the end year.

Example: If the filter is set to show records from 2020 to 2024, then the desktop report is showing all data but exported paginated report is not showing data from 2024.

How can I fix this?

[v-jingzhan-msft]

Hi @Vishruti 

Are you using a Between Year slicer in a Power BI report and using this slicer to filter data in a paginated report visual in the same PBI report? If so, this video from Guy in a Cube may be helpful: Create a date range parameter with Power BI Paginated Reports - Guy in a Cube

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!