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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Advocate II
Advocate II

Adding Dynamic Page Size and Page Numbers to Table in Power BI

Hello Power BI Community,

I've been working on a project where I connected to the Sample Super Store data Excel as a data source and created a table. However, I'm facing a challenge with pagination. I need to set the page size dynamically and add page numbers to the table without using the pagination option already available in Power BI.

The reason for this requirement is that my actual real-time project involves tables with 30-40+ calculated columns, and I need a more customized approach for pagination.

I'd appreciate any insights or suggestions on how to achieve dynamic page size and page numbers in Power BI tables.

Thank you in advance for your help!

Best regards,
Manoj Prabhakar

Community Support
Community Support

Hi @manoj_0911 ,

Please try the following methods and check if they can solve your problem:

1.Open the report in Power BI Report Builder.


2.Navigate to the Report Data pane.


3.Drag the Page Number field from the Report pane to the report header.


4.You can also view the following link to learn about how to display page numbers.

Display page numbers or other Power BI paginated report properties - Power BI | Microsoft Learn


Best Regards,

Wisdom Wu

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

Super User
Super User

Hi , 

What do you mean dynamic page size? you want the report page to increase based on the number of records?


Page and visualizations sizes cannot be dynamic, what you can do is to create a pagination for the table view for example:


Miguel Félix

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português

Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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