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
Solution SageAlso, if I could lock the Total row in place, I would be able to color that entire row consistently by placing a same-colored object behind the matrix