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
ND_C
Regular Visitor

Wrong cell padding in matrix visual when report is first opened

I'm running into some strange behavior with matrix visualizations, similar to that described (but not resolved) here.  When the report is first opened, something about the cell size or padding isn't being rendered correctly.  Anything that causes the matrix to refresh, such as interacting with a slicer, will then cause the matrix to start rendering with the expected cell sizes.

 

Screen caps of what I'm describing can be seen below.  In the first image, the report has just been opened; you can see scroll bars in 3 of the 5 matrix visuals.  In the second image, one of the checkboxes in the Month slicer has been un-checked and then re-checked.  The scroll bars have disappeared, and the row padding in the top 3 visuals is rendering properly.

 

On first open (note scrollbars):

ND_C_0-1673900624905.png

 

After slicer interaction (scrollbars gone, visual looks as it was designed to):

ND_C_1-1673900664983.png

 

 

A sample workbook for replicating the issue can be grabbed here: https://www.dropbox.com/s/r41mb8oecka5df6/matrix_example.pbix?dl=0

1 ACCEPTED SOLUTION
tex628
Community Champion
Community Champion

Hi @ND_C , 

I'm not completly sure why but the issue seems to be related to the DIN font. When i change the font to Segoe UI i no longer have the issue.... 

Might be a case for the Issues channel? 

Br,
J


Connect on LinkedIn

View solution in original post

4 REPLIES 4
tex628
Community Champion
Community Champion

Hi @ND_C , 

I'm not completly sure why but the issue seems to be related to the DIN font. When i change the font to Segoe UI i no longer have the issue.... 

Might be a case for the Issues channel? 

Br,
J


Connect on LinkedIn
ND_C
Regular Visitor

You are in fact correct.  That is... very odd.  I'll post something to Issues, thanks very much.

ND_C
Regular Visitor

Hi @amitchandak ,

 

in this case, I had already set the widths and turned off the auto-size option (you can test this yourself in the attached .pbix file).

 

I also just noticed another behavior that seems, to me, like it would indicate a bug in how Power BI is initially rendering the cell size: if I open the file, change an element, and then click "undo," Power BI re-renders the visuals correctly.

 

First open (scrollbars visible): 

ND_C_0-1673964544386.png

 

Unrelated element change (in this case, I moved the slicer location):

ND_C_1-1673964590154.png

 

Clicked undo (no more scrollbars):

ND_C_2-1673964636703.png

 

 

I know this seems minor, but in my actual production report it results in the user, when opening the page, being greeted by illegible visuals because scrollbars are obscuring the data:

 

ND_C_4-1673965265634.png

 

amitchandak
Super User
Super User

@ND_C , Power bi keeps on adjusting the width, First set the width as per need and then switch off auto width and try

 

amitchandak_0-1673921746147.png

 

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.