cancel
Showing results for 
Search instead for 
Did you mean: 

Bug Fix request: Total Column in a matrix changes width (gets shrinked) when empty

'Total' column in a matrix is getting resized (shrinked) whenever report filtering results in a blank dataset (no data returned). Unfortunately the column stays shrinked even after data re-appear in a matrix, causing its layout to be damaged (field width is too small to fit the length of the number, causing number wrapping, rows taking extra space etc.). It's extremely annoying, because you have to manually correct 'Total' column width every time it happens.

This issue occurs even with 'Auto-Resize' option switched off, applies only to 'Total' column (regular columns keep their widths as they should)

Status: New
Comments
v-lili6-msft
Community Support

hi

I have tested on my side, it works well.

for example:

I insert a rectangle shape as a reference point.

1.JPG

 

when I filter out all the data results in a blank dataset, and it still works well after remove filter.

 

my power bi desktop Version: 2.90.782.0 64-bit (February 2021)

 

could you please share your sample pbix file for us have a test? that will be a great help.

 

Regards,

Lin

bruno_obata
New Member

I have the same problem. It is really annoying. Does anyone know how to fix this?

fat_cat
New Member

Hi Lin, I can't make my pbix file available right now, as it includes sensitive data. I hope the example screenshots may help:

 

Step 0 - my table looks like this:

fat_cat_0-1616003320918.png

Step 1 - slicer selection returns no data:

fat_cat_2-1616003674997.png

Step 2 - bring back previous slicer selection - my table looks like this:

fat_cat_3-1616003764480.png