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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Avivek
Post Partisan
Post Partisan

Having issue in the matrix table

I have a matrix table with sales amount and % value.Capture.PNG

The total of sales needs to be shown but total on %  needs not be shown. 

This is a drillthrough page, if we filter by some account and there is no sales value for that account then it appears something like this:-

 

Capture.PNG

Now on the right side filter if I remove the parent account filter visual looks like this-

 

Capture.PNG

Is there a way of not showing this ... in % total even when some filters are used like done in my above scenario.

1 ACCEPTED SOLUTION
MFelix
Super User
Super User

Hi @Avivek ,

 

Do you have the auto-size option turn on? If you turn off that option and then reduce the size of this column to the minimum the column will always be hidden.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

3 REPLIES 3
MFelix
Super User
Super User

Hi @Avivek ,

 

Do you have the auto-size option turn on? If you turn off that option and then reduce the size of this column to the minimum the column will always be hidden.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Hi @MFelix , as it turns out you were right, autowidth for column header was toggled off, after switching it to on this works now. Thankyou @MFelix 

Yes @MFelix , autowidth is off already but this issue still persist.

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

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.

Top Solution Authors