Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 for JIRA Due Date, JIRA Status and Days to Complete.
Thank you
Instead of putting fields (JIRA Due Date, JIRA Status, Days to Complete) in Values, place them in Rows.
If these three fields are moved to "Rows" then we would not be able to see the project respective due date and status on the same row
This will be the result :-
What we want is still able to see the respective Status/Due Date for each project
Can't you use a table visual to show this information?
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:
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.
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...
Did you ever figure this out? I also am looking for this solution
Hi,
You should be able to solve it with this pattern
=if(hasonevalue(Data[Description]),[your measure],blank())
Hope this helps.
Nope - I just leave the sub-totals there
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
72 | |
70 | |
37 | |
29 | |
27 |
User | Count |
---|---|
91 | |
49 | |
45 | |
38 | |
36 |