cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TabathaN
Advocate I
Advocate I

Matrix Auto-Size Not Working Correctly

I cannot share my file due to privacy issues so hopefully all of these screenshots will be helpful.

 

Example #1

There are no visual or page level filters set, no slicers and the column auto-size is set to "On". From this veiw everything looks like it's working correctly, especially since the number of characters in the total row are greater than the ones of the column header.auto-size example #1.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Example #2

I have added one page level filter to example #1 and the column auto-size remains "On". You can see here that the auto-sizing breaks and does not format the May column correctly.

auto-size example #2.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Example #3

Adding additional selections to the page level filter still provides the same result as example #2auto-size example #3.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Example #4

Clearing the page level filter and using a visual level filter provides the same resultauto-size example #4.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Example #5

Clearing page and visual level filters and using slicers also results in the same outcome.auto-size example #5.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

I have searched in the fourm for answers to this and have looked at any possible formatting selection I could make to correct this (I'm still new to PBI so that doesn't mean a whole lot lol) but I cannot figure it out.

 

Does anyone know how to fix this? It seems as though it's the filters causing the issue...?

 

Supplementary Information:

The value column is a count of the "parent appointment ID" which is a numerical (whole) number.

I have had this happen on more than one occassion in more than one page.

My desktop PBI is current - Version: 2.65.5313.841 64-bit (December 2018)

If I manually adjust the May column and go up or down a level the column will revert back to the wrong format where the total does not fit as seen in examples 2-5

2 REPLIES 2
Greg_Deckler
Super User
Super User

Have you tried turning the auto-sizing to off? Then manually set your column widths to their maximum expected size. Not great necessarily but I think that should work.


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

@Greg_Deckler

I have but unfortunatley the numbers can vary so much from level to level depending on what filters are in place that I don't feel like this is an adequate solution 😞

I really feel like this is some type of bug but was hoping there was an easy answer out there that would solve the auto-sizing issue so I won't have to make these chages all the time.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.