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.
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.
Solution SageYes, 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.