PowerBI ArcGIS - set static records

[Murcia92]

Hello all. I am trying to build a report with more than 500K records, and the system is randomly hiding record in my report. I know there is a limitation on the number of records displayed with the standard functionality, but I would like to set a portion of the records (200 approx) to always be displayed. Does any one know what is the paratmeter for ArcGIS to hide data and how to set records as always displayed?

Thanks!

[amitchandak]

@Murcia92 , we can use the TOPN visual filter or create pagination using the Window function

Power BI Visuals using Window Functions: A Step-by-Step Guide, How to do it- Power BI Visuals using Window Functions: A Step-by-Step Guide, How to do it

[Murcia92]

Thanks a lot @amitchandak . since we have almost 200 records in the visual, we were not able to use the TOPN visual filter. Do you have a tutorial of gor wo use the pagination? is there any way to set a property directly in the data set to define a paramater as "Always show"?