Formatting Column Totals in Matix when moving values to row groups

[rloski-public]

I have a matrix.  The row group is Sales Rep and the Column group is Month.  The values are various measures.

I set the Values option on the matrix "Switch values to rows" to on, which displays each value as a row in the matrix.

  

It displays quite nicely with one exception.  Half of my screen has the totals for each column, one row for each of the values.

What are the options for displaying the totals?  I would like to have the totals as an unexpanded group at the bottom of the matrix where the user can expand the column totals when she wants.  Alternately, I want the totals at the very bottom of the matrix so that the user has to scroll to the bottom to find the column totals.

The bottom line is that I don't want to block the user from seeing as much of the Sales Rep data as they can (an multiple Sales Reps as well) without the totals blocking. 

[amitchandak · Accepted solution]

@rloski-public , To hide and show option is under sub total for total(too) in matrix visual

#shorts #learnpowerbi Power BI how to show/hide subtotal, grand total| Matrix Per Row Level - #shorts #learnpowerbi Power BI how to show/hide subtotal, grand total| Matrix Per Row Level

[rloski-public]

One follow up question before I accept this as answer as solution.  Is there a way to set the visibility of total/subtotal based on a measure?  My plan would be to create a measure driven by a slider selection to show or hide the total/subtotal.

[rloski-public]

I just copied the Matrix.  In one I hid the row subtotals.  In one I removed the row header, so that all I had were my values.  I then used book marks and two buttons to show and hide the total and details.