Forum Discussion
Solution SageHow to fix total matrix row
Hi Elena_Kalina
We understand the design limitations you're experiencing. As danextian mentioned, the Grand Total row in a matrix visual stays at the bottom only if the visual is scrollable. If all rows fit in the visual, the total appears after the last row, which may vary depending on the data. There currently isn't a setting to always keep the Grand Total at the bottom, no matter the number of rows.
Regarding grid line visibility on dark backgrounds, this is a known issue. You might suggest that the designer use a lighter background or adjust the grid line transparency to improve contrast until the issue is resolved.
Regards,
Karpurapu D,
Microsoft Fabric Community Support Team.
Solution SagedanextianThank you for your attention to my issue. I don’t need to explain it in more detail—I’m specifically referring to the Grand Total row. The problem persists regardless of the matrix layout or state.
Why do I need to fix the Total row?
The client requires a table view with:
A highlighted header
A Total row
No vertical column separators
When I set colors for the headers and Total row (while making grid lines blend with the table body), the light grid lines become visible against the dark background.
Since the header position is fixed, I can overlay a shape to mask the issue there. But this won’t work for the Total row—its position keeps changing unpredictably.
Why does it move?
The matrix displays metrics for each client’s managers. Client A might have 20 managers (filling the designated table space), while Client B has only 2 managers—causing the Total row to jump upward
Super UserThe gridline still appearing against a dark background despite being disabled is a known bug. Try choosing a lighter background instead
Although the grand total can be frozen, it will appear just after the last row if there are only a few rows. It remains fixed only when the visual becomes scrollable - i.e., when there are more rows than can be displayed within the current visual size. There is no available option to change this.
- Elena_Kalina
Yes, I understand this, but our designer continues to insist on a dark background. Therefore, I was forced to contact the forum for help
v-karpurapudCommunity Support
Hi Elena_Kalina
We understand the design limitations you're experiencing. As danextian mentioned, the Grand Total row in a matrix visual stays at the bottom only if the visual is scrollable. If all rows fit in the visual, the total appears after the last row, which may vary depending on the data. There currently isn't a setting to always keep the Grand Total at the bottom, no matter the number of rows.
Regarding grid line visibility on dark backgrounds, this is a known issue. You might suggest that the designer use a lighter background or adjust the grid line transparency to improve contrast until the issue is resolved.
Regards,
Karpurapu D,
Microsoft Fabric Community Support Team.