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.
Helpful resources
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
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.
