Forum Discussion
Remove totals in matrix table
According to me marix properties->General->Row Totals on/off should work
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.
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.
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.
RitaPT sadly there seems to be no solution for this. I don't know if anyone has put in a feature request for it.
please see my post on page 3 (4/20/17); it explains the design. To reduce your totals - reduce your rows by modeling/merging row data. for now that is the only method to manage this. perhaps in the future there will be an explicit on/off for individual row totals but that is not there now.
My apologies CahabaData, I misread your post. My problem is different to yours and to this thread - I wan't to limit totals on individual columns of a matrix not rows. I should start a new thread on that.
