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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Multi-Row Matrix Ranking to split Matrix over multiple pages

Dear BI Community,

 

I have created the below matrix that has rows division, matter type, and values being count of matters and a rankx of the matter types so that the matrix includes only the top 3 matter types by using a less than or equal to filter of 3 on the rankx measure values.

 

Because this matrix scrolls across multiple pages due to having many rows, I was wondering if I could somehow add a hidden index column to this matrix so that I could copy it onto the next page and filter the first matrix to the first N rows that are visible and filter the matrix on the next page to the next N rows that are visible. Is there any way to do this please? Thank you for your help everyone.

 

AndrewPanchal_0-1649400268554.png

 

1 REPLY 1
lbendlin
Super User
Super User

You may want to look into paginated report visuals.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.