Forum Discussion

New Member

10 years ago

Solved

Remove totals in matrix table

How do I remove totals from the rows. When I make a matrix the columns delivers a total for every column, distubing the picture.

Tsanka
10 years ago
According to me marix properties->General->Row Totals on/off should work

Frequent Visitor

9 years ago

KarlinOz I have the same problem that you. I only want to show some column subtotals. Did you find a solution for that?

Thanks a lot.

Advocate III

9 years ago

RitaPT see my 2nd post here http://community.powerbi.com/t5/Desktop/URLs-in-Matrix-are-clickable-links-when-as-Rows-but-not-as/td-p/185776/page/2 to see my work-around to remove specific columns from showing a total.

CahabaData
Memorable Member
9 years ago
good input; to summarize your post in other thread:

a work-around for suppressing Totals of those columns which you don't want: In the formatting area > Column formatting
Select your text column, change the Font color to match your background colour, turn Color values Off, Color subtotals and Color totals On. Repeat for all your text columns.