Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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.
You may want to look into paginated report visuals.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 63 | |
| 55 | |
| 42 | |
| 41 | |
| 23 |
| User | Count |
|---|---|
| 171 | |
| 136 | |
| 119 | |
| 80 | |
| 54 |