How to fix the matrix column width even after data refresh

[Usha_pk]

Hi team,

@Ritaf1983 @amitchandak @Greg_Deckler @parry2k 

Is there any way to fix the matrix colum width even after refreshing the data. I have manually set the width of the columns and then turned off auto-size width and then text wrap is also on. However after data refresh, the width of the column gets changed. Could you please suggest on this, thank you!!!

[Ahmedx]

Refer to this solution

https://data-goblins.com/power-bi/set-column-widths

[Ritaf1983]

Hi @Usha_pk 
Yes, please refer to the linked workaround :

https://www.youtube.com/watch?v=4ZtuifazEHk&t=190s

If this post helps, then please consider Accepting it as the solution to help the other

members find it more quickly

[Usha_pk]

hi @Ritaf1983 , this works only for one measure. But how to achieve this in case of more than one measure. Could you please help as quickly as possible.

[Usha_pk]

Hi @Ritaf1983 

The requirement is like, there is different width for each of the cell in the matrix, so we have adjusted manually according to the requirement and then turned off auto-size width and turned on text wrap as well. Now after the refresh the new data is changing its formatting and it doesn't follow the adjusted width. Could you please help on this.