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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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