Forum Discussion
Remove totals in matrix table
According to me marix properties->General->Row Totals on/off should work
Updated action list:
Select Matrix > Format tab > Subtotals > Row Subtotals > toggle to off
More words (same actions)
Select the Matrix >
In the visulaizations menu select "Format" tab (the painbrush) >
Select the submenu "Subtotals" >
In the list item "Row Subtotals" Toggle the slider to off.
swmcbri Thanks for the suggestion but we previously tried this. The action you are suggesting removes all subtotals, including that of Revenue, Total COS and Total SG&A so it is not a suitable solution. The solution we are looking for would be more akin to what you see in an Excel pivot where you can remove the grand totals for either rows or columns. While Power BI does have formating for grand totals, the abilty to exclude the grand total is not an option. Furthermore, if you were to attempt to change the font white (or whyatever your background is) the row label of "total" remains intact. Finally, text cannot be reduced below a point size of 8 so setting it to zero is not a viable option either. Perhaps someday Microsoft will allow the ability to exclude the grand total independent of the sub total.