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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

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
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors