The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
Solved! Go to Solution.
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.
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/