March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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.
Solved! Go to 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 , 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
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.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
128 | |
90 | |
75 | |
56 | |
53 |
User | Count |
---|---|
200 | |
104 | |
101 | |
67 | |
55 |