Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
HiHelloWorld
New Member

Paginated Report in Power BI Report Not Updating with Filters

Scenario:
I have a Power BI report designed to display student attendance data. The report includes a paginated report visual along with two filters:

  1. Filter 1: Student Name
  2. Filter 2: Date

The paginated report visual is intended to show a table of student attendance records based on the selected filters.

Issue:
When applying new date filters subsequently, the paginated report fails to update accordingly.

For example, if Student A attended classes until May 1, 2024, and I apply a date filter from April 1, 2024 to May 5, 2024 , the paginated report correctly displays data. However, upon applying a subsequent date filter from May 5 to May 10, 2024 on same student, the paginated report continues to show the previously filtered data row instead of showing blank. (By right the paginated report table should show blank)

 

***it works fine if data row exist after filter selected, but when it should return empty row after filter selected then the paginated report continues to show the previously filtered data row

1 REPLY 1
Anonymous
Not applicable

Hi @HiHelloWorld ,

1. Ensure that the "Auto-apply filters" option is turned on for your paginated report visual. This setting controls whether the report filters are automatically applied to the paginated report visual. By default, this option is turned off, which means your paginated report visual remains unchanged as you adjust filters in your Power BI report. 
Create and use the paginated report visual - Auto-apply filters

2. What is your filter logic and how does it handle empty sets?

Best Regards,
Gao

Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.