Power bi table or matrix or table to display only x amount of rows at a time

[vilenm]

Hi

 We have a tabular model and at times we would display some rows via matrix or table, due to the large amount of rows, is there some way to only display for eg. 5000 rows on a table, and have a next button to show the next 5000 rows instead of displaying everything which I doubt will have a enough memory for the visual to display?

[jbocachica · Accepted solution]

Hi, in order to paginate I would recomend this:

1. Create an index column starting in 1
2. Divide that column by the size of your pages (5000 in this case for example)
3. Roundup the division (1/5000) = 1 --- (5000/5000) = 1, you get the point.
4. Create a filter and use the second column as a filter

Regards! 

[jbocachica · Accepted solution]

Hi, in order to paginate I would recomend this:

1. Create an index column starting in 1
2. Divide that column by the size of your pages (5000 in this case for example)
3. Roundup the division (1/5000) = 1 --- (5000/5000) = 1, you get the point.
4. Create a filter and use the second column as a filter

Regards! 

[vilenm]

Hi John

Thanks this can work! . How would I implement point 2 and 3 ? maybe example?

thanks

[v-yingjl · Accepted solution]

Hi @vilenm ,

After you create an index column in power query, you can create a custom column like this as @ jbocachica mentioned(in my sample, use 20 as the base for paging):

Close & apply it in power query, use the custom column as the filter that you could get the expected result.

Attached a sample file in the below, hopes it could help.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.