Matrix Visuals - How to remove the grand total and keep subtotals?

Viewed 17045

In Power BI Desktop, is there a way to keep the subtotals and remove the grand total in a matrix?

For example, in the following matrix, it doesn't make sense to add values for multiple years of sales (thus, also to keep a grand total row), but it is necessary to add values for different months in the same year:

enter image description here

2 Answers

You can hide the grand total in Format > Subtotals:
First enable Per row level. Then disable the switch that just appeared below with the desired column title (ano in this case).

Related