Forum Discussion
Horizontal Scrolling Pushes Down Rows in Report Builder
I ran into an issue where scrolling horizontally causes the first columns in my tablix to move down a row, but the data in all other columns stays in the same spot so the labels are misaligned.
I found this thread which claims that the issue was fixed in a Dec 2021 release, but I am still experiencing the issue. Is anyone aware of a solution for this or does this still need to be fixed on the back end? https://community.fabric.microsoft.com/t5/Desktop/Paginated-Report-horizontal-scrolling-breaking-visual/td-p/2222883
I am running 15.7.1804.21 and I am still experiencing this issue consistently. Had to obfuscate data, but can see the difference in bottom of these images.
Hi jsek
In a matrix, horizontal scrolling only applies to the values. The row and column categories remain fixed, so this is expected behavior, not a bug. That’s why misalignment appears when the table has many categories.
If you need to display a wide table, there are several options:
-
Switch the visual from a matrix to a flat table.
-
Keep the matrix but restructure the hierarchies vertically.
-
Expand the canvas size to reduce the need for scrolling.
-
Use tooltips to display additional details without adding more visible columns.
-
Leverage field parameters to let users switch between sets of fields instead of showing all columns at once.
In other words, it’s not an issue but a matter of selecting the right visual and interaction design to fit your scenario.
The pbix with the examples is attached
If your case is different, please consider sharing a sample PBIX file (with sensitive data removed) via a public cloud service, since based on the screenshots alone it’s not possible to fully understand the issue.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
-
4 Replies
Hi jsek
In a matrix, horizontal scrolling only applies to the values. The row and column categories remain fixed, so this is expected behavior, not a bug. That’s why misalignment appears when the table has many categories.
If you need to display a wide table, there are several options:
-
Switch the visual from a matrix to a flat table.
-
Keep the matrix but restructure the hierarchies vertically.
-
Expand the canvas size to reduce the need for scrolling.
-
Use tooltips to display additional details without adding more visible columns.
-
Leverage field parameters to let users switch between sets of fields instead of showing all columns at once.
In other words, it’s not an issue but a matter of selecting the right visual and interaction design to fit your scenario.
The pbix with the examples is attached
If your case is different, please consider sharing a sample PBIX file (with sensitive data removed) via a public cloud service, since based on the screenshots alone it’s not possible to fully understand the issue.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
-
Hi jsek,
Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to Ritaf1983 for prompt and helpful response.
Just following up to see if the Response provided by community member were helpful in addressing the issue. If one of the response helped resolve your query, please consider marking it as the Accepted Solution. Feel free to reach out if you need any further clarification or assistance.
Best regards,
Prasanna KumarHi jsek,
Just following up to see if the Response provided was helpful in resolving your issue. Please feel free to let us know if you need any further assistance.
Best regards,
Prasanna Kumar
Hi jsek,
Just following up to see if the Response provided by community member were helpful in addressing the issue. If one of the response helped resolve your query, please consider marking it as the Accepted Solution. Feel free to reach out if you need any further clarification or assistance.
Best regards,
Prasanna Kumar
