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
ssspk
Helper III
Helper III

How to remove the total for the column count using component Matrix component?

Hello Team,

 

Below is my requirment,
The display should show as like in the image but i have to remove the final TOTAl and its count(2409) in last row.

Matrix component_2.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

By using  Format Visual -> Row subtotals OFF it will off the Total =2409.It also removed the first master keyword count as shown in the below image. Also it removes the total and its count(2409) value in the last row.

 

Matrix component_1.png

 

row_removal.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

It should not remove the count value(172) for the first master keyword as shown in the image 1 attached.

How to achieve it.?

 

Thanks and Regards,

Siva

 

1 ACCEPTED SOLUTION
mdaatifraza5556
Super User
Super User

Hi @ssspk 

Can you please try the below steps ?

 

Go to visualization pane --> Click drop down arrow on Row subtotals --> Enable Per row level --> select your top level --> open drop down of Rows --> Disabled show subtotal




Screenshot 2025-07-16 102842.png

 

 

 

 

If this answers your questions, kindly accept it as a solution and give kudos.

View solution in original post

2 REPLIES 2
ssspk
Helper III
Helper III

Hi @mdaatifraza5556 ,

Thank you for your solution and its working for me.

mdaatifraza5556
Super User
Super User

Hi @ssspk 

Can you please try the below steps ?

 

Go to visualization pane --> Click drop down arrow on Row subtotals --> Enable Per row level --> select your top level --> open drop down of Rows --> Disabled show subtotal




Screenshot 2025-07-16 102842.png

 

 

 

 

If this answers your questions, kindly accept it as a solution and give kudos.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

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.