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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
mbalraj
Regular Visitor

Report should show only 30 rows by default

Hello

 

I have a report that loads about 30k rows.

 

I would like to restrict the report to show either blank or to list 30 rows on default. 

The user should then be able to select filters and then click a "Load More" button and then all rows based on the filters should be shown.

 

Please let me know how I can achieve this.

 

Regards

Matthew

1 ACCEPTED SOLUTION
v-jianboli-msft
Community Support
Community Support

Hi @mbalraj ,

 

You can use bookmark and filter to achieve this goal:

First, filter the top 30 rows of the data, use it as the default view.

vjianbolimsft_0-1658307260866.png

 

Output:

vjianbolimsft_1-1658307260869.png

 

Then clear the filter and add bookmark:

vjianbolimsft_2-1658307260870.png

 

Create a blank button, set it as bookmark

vjianbolimsft_3-1658307260872.png

 

vjianbolimsft_4-1658307260873.png

 

vjianbolimsft_5-1658307260874.png

 

Final output:

vjianbolimsft_6-1658307260875.png

 

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-jianboli-msft
Community Support
Community Support

Hi @mbalraj ,

 

You can use bookmark and filter to achieve this goal:

First, filter the top 30 rows of the data, use it as the default view.

vjianbolimsft_0-1658307260866.png

 

Output:

vjianbolimsft_1-1658307260869.png

 

Then clear the filter and add bookmark:

vjianbolimsft_2-1658307260870.png

 

Create a blank button, set it as bookmark

vjianbolimsft_3-1658307260872.png

 

vjianbolimsft_4-1658307260873.png

 

vjianbolimsft_5-1658307260874.png

 

Final output:

vjianbolimsft_6-1658307260875.png

 

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak
Super User
Super User

@mbalraj , refer if this blog can help

https://www.fourmoo.com/2017/10/31/power-bi-how-to-do-pagination-in-power-bi-reports/

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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.

Top Solution Authors