Fixed Column width for dynamic label header of a matrix

[Anonymous]

Hello

I got a matrix that has 5 columns, 2 of which are fixed (Actual Trim, Budget Trim), and 3 dynamic columns which are based on the year selection, (Budget 2022 and Forcast 2022 , Year 2021), when I tried to implement a standard width column, with the classic method, creating a measure ColWid = "000000000", and drag in/off from the matrix) when I select another year, the matrix's columns aren't longer with the standard size, but the 3 dynamic columns change their width.

Its a way to avoid this?

Thanks

[nancy_a_shirley]

I have tried this as well...  but it doesn't work.  It appears to be a bug in Power BI.  The name of the functionality makes you think it will hold the column width but it does NOT.

[Anonymous]

Hi @Anonymous ,

According to your statement, I think you want to fix the width of your dynamic columns in your matrix. Here I suggest you to try to turn off the "Auto -size width" option in matrix format.

Result in my sample is as below.

Turn on:

Turn off:

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi,

thank you for your response, but It doesn't work, this is my case: