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

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Reply
Anonymous
Not applicable

hide row from table but include in row totals

Hi all,

 

How can i hide a row in a matrix table but include the numbers in the the total. 

 

 

How can i for example hide the row named "weird account" entirely from the table visual, but still keep its 5 in sales in the total at bottom?

cap4.JPG

3 REPLIES 3
Anonymous
Not applicable

Hi @Anonymous 

 

Techinically this is not possible as far as I know.

However you can cheat and overlap 2 tables.

check out the link:

Hide Row But Not Total

 

Mark this as Solution if this helps you Man Happy

Anonymous
Not applicable

Hi,

 

Do we have any update on this

v-yulgu-msft
Microsoft Employee
Microsoft Employee

Hi @Anonymous ,

 

I'm afraid this is not supported by now.

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.