Forum Discussion
Power ParticipantFormatting Matrix Visuals
Yes, it does seem impossible to change just the Grand Total cell's background colour, since the Row Grand Total formatting doesn't apply to that cell and Column Grand Total formatting applies to the entire total column!
One workaround would be to create an appropriate visual calculation that returns the desired background colour for cells in the Total row, and apply that using conditional formatting. In your case this might look like:
Background colour = IF ( NOT ISATLEVEL ( [Age Profile] ), "#D2DFE6" )Here's an example using a Contoso dataset (attached):
Super UserYes, it does seem impossible to change just the Grand Total cell's background colour, since the Row Grand Total formatting doesn't apply to that cell and Column Grand Total formatting applies to the entire total column!
One workaround would be to create an appropriate visual calculation that returns the desired background colour for cells in the Total row, and apply that using conditional formatting. In your case this might look like:
Background colour =
IF (
NOT ISATLEVEL ( [Age Profile] ),
"#D2DFE6"
)Here's an example using a Contoso dataset (attached):