Forum Discussion
How to fix column widths in a matrix where column headers change with each refresh
Preeti_Yadav
I tried turning off both the auto-size and text wrap, however, whenever the column headers change, i.e, replaced by a new column header name/text, it doesn't work. This is because the headers are also dynamic in nature.
Is there any way we can completely fix the column width so that it never changes irrespective of any change in the data?
Hi Anonymous ,
Power BI will automaticlly set auto-size width for new column. So currently, the best workaround should be turn off Auto-size with and Text wrap option in format mentioned above and then drag the width of column header manually.
Your demand is a good idea, while it is not supported to implement in Power BI currently.
You can vote up this idea for this function: Auto Fitting Column Width
Or you can submit a new idea to improve the Power BI.
It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.
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 Anonymous Did you get a Solution. with May 2023 PowerBi desktop i still am observing this issue. When the Periods are used as column for a selected period the columns will change. i lose all the formatting. the Auto-width disable and Text wrap does not work. Please advise.
