Forum Discussion
hushpuppies
3 years agoFrequent Visitor
how to exclude/hide/remove specific row subtotal in Matrix visual
Hi, Is there a way to exlude/remove/hide specific row subtotal in Matrix visual? Basically, I would like subtotal for Budget, Actual and Variance to be shown but to remove/hide/exclude sub total...
dhananjaym09
3 years agoFrequent Visitor
Yes, it is possible to exclude or hide specific row subtotals in a Matrix visual in Power BI. Here's how you can achieve it:
- Select the Matrix visual on your report.
- In the Fields pane, locate the field(s) for which you want to exclude subtotals (e.g., JIRA Due Date, JIRA Status, Days to Complete).
- Right-click on the field name and choose "Don't summarize" from the context menu. This will remove the subtotal for that specific field.
- Repeat the above step for each field that you want to exclude from subtotals.
- Refresh the visual to see the changes.
By setting the aggregation for those specific fields to "Don't summarize," the Matrix visual will exclude subtotals for those fields while still displaying the subtotals for Budget, Actual, and Variance.
- hushpuppies3 years agoFrequent Visitor
Hi DJ
Thanks for the suggestion. I have changed it to Don't Summarise and refresh the page...it is still showing the sub totals...
- itshotout2 years agoNew Member
Did you ever figure this out? I also am looking for this solution
- hushpuppies2 years agoFrequent Visitor
Nope - I just leave the sub-totals there