Question

You have a matrix visual showing monthly Revenue by Product Category. Category names are on rows, months are on columns, and Revenue is the value. Management wants the background color rules (green for high, red for low) to apply ONLY to the row-level subtotals for each category, not to the individual monthly cells. In the conditional formatting dialog for background color, which setting lets you accomplish this?

Accepted Answer

Set the 'Apply to' option to 'Subtotals only' for the Revenue value's background color rule

Answer

Enable 'Show on rows' in the matrix formatting pane before adding the conditional formatting rule

Answer

Create a separate measure that returns BLANK for non-subtotal rows and format the whole matrix on it

Answer

Turn off 'Stepped layout' so subtotals appear on their own line, then apply the rule to values