Remove column total from matrix

[mp390988]

I have a matrix visual thats show 2 different column totals and I want to remove the one marked in yellow but when I turn off column totals it removes both columns from the total. Does anyone know how to remove just one of the columns from the total for a matrix visual?

[v-venuppu]

Hi @mp390988 ,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please accept it as a solution and give it a 'Kudos' so other community members with similar problems can find a solution faster.

Thank you.

[v-venuppu]

Hi @mp390988 ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-venuppu]

Hi @mp390988 ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-venuppu · Accepted solution]

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.

[hnguy71]

I believe it's either all on or all off for each specific column. You can't turn off specifc totals for specific measures.