Forum Discussion
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
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.
Output:
Then clear the filter and add bookmark:
Create a blank button, set it as bookmark
Final output:
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.
2 Replies
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.
Output:
Then clear the filter and add bookmark:
Create a blank button, set it as bookmark
Final output:
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.
mbalraj , refer if this blog can help
https://www.fourmoo.com/2017/10/31/power-bi-how-to-do-pagination-in-power-bi-reports/
