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

[fat_cat]

'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)

[v-lili6-msft]

hi

I have tested on my side, it works well.

for example:

I insert a rectangle shape as a reference point.

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]

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

[fat_cat]

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:

Step 1 - slicer selection returns no data:

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

[CerbPBI]

The way I fixed it is making sure the slicers do not have values for which we expect no rows.

As long as I make sure any filters applied via slicers yeild a non null row, the fixed columns stay.

I applied on each slicer measure not blank filter to ensure I always have a valid slections via slicers.

[Anonymous]

I am having this issue as well and it is incredibly frustrating. I don't understand why turning off "auto-size column width" or disabling text wrap does not work for the totals. 

I've found older threads of this same issue, this needs to get resolved ASAP.

[Anonymous]

same issue. on the example given above, the grand total width got resized whenever string length of all values are smaller than the column header. ('suma' has 4 characters while 0/blanks have 0/1 character)  

[JonasGuimaraes]

Hello,

Does anyone found a fix for the issue? I am also getting the exact same problem and it is really annoying.

[Hansupansu]

It is crazy this bug has existed for several years now. This really really needs to be fixed.

[atriq1]

Yes! This is a severe issue. Microsoft please pay attention! It ruins user experience.
Not only about slicers as well. When clicking any Table/Matrix cell filters other Table/Matrix, and a blank rows returns, this also happens.

[paulina_kurtz]

Here's a sample file showing this error:

https://drive.google.com/file/d/1ObrkhzyvKKMk6LfqznFZv0OJsWlML62X/view?usp=sharing

The matrix has auto-width off. Simply switch the year filter from 2020 to 2021 and then back to 2020 and see the total column resizing.

It would be great if anyone from the support team could look at this and push it to be fixed.