Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
hushpuppies
Frequent 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 for JIRA Due Date, JIRA Status and Days to Complete.

 

hushpuppies_0-1689227096887.png

 

Thank you

 

8 REPLIES 8
dhananjaym09
Frequent Visitor

Instead of putting fields (JIRA Due Date, JIRA Status, Days to Complete) in Values, place them in Rows.

dhananjaym09_1-1689229702596.png

 

 

 

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 :-

hushpuppies_1-1689230410320.png

What we want is still able to see the respective Status/Due Date for each project

hushpuppies_2-1689230461616.png

 

Can't you use a table visual to show this information?

dhananjaym09
Frequent 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:

  1. Select the Matrix visual on your report.
  2. 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).
  3. Right-click on the field name and choose "Don't summarize" from the context menu. This will remove the subtotal for that specific field.
  4. Repeat the above step for each field that you want to exclude from subtotals.
  5. 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.

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...

hushpuppies_0-1689229258108.png

 

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Nope - I just leave the sub-totals there

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.