Remove column total from matrix

Hi mp390988 ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you hnguy71  for the prompt response.

In Power BI Matrix visuals, unfortunately, you cannot selectively remove column totals for just one column using the built-in visual settings. The "Column subtotals" toggle applies globally to all columns in that group or level but not individually.

Here are few possible ways based on your use case:

1. Use Measures with Conditional Logic

You can modify your measure to return BLANK() when it is being evaluated in the total row. Example:

Measure=
IF(
HASONEVALUE(DimTable[ColumnName]),
SUM(FactTable[Value]),
BLANK() -- hides the total
)

• Use this only for the measure where you don’t want totals.
• The other measure (that should show totals) can stay unchanged.

2. Use a Duplicate Matrix for Layout Control

Create two matrix visuals:

One for the measure with totals.

One for the measure where you want no totals (and use the logic above).

Align them side-by-side to appear as one.

It will gives layout control.

3. Use a Custom Table Visual

For full control, switch to a Table visual and build totals manually using UNION() and ROW() logic in a summary table.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

 Thank you.