Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Matrix Column Headers - Set Width for all columns

Has anyone come up with a solution to set the width of all matrix columns and not have them attempt to auto-fit based on the headers?  This has been requested of Microsoft since at least 2017, with numerous suggestions having thousands of up-votes, with no progress that I'm aware of.  A 5 second process in Excel is nearly impossible in Power BI.  I have many case where I'll have more than 100 columns that can be reduced by slicer selections, and can also have new additions in the data on a regular basis.  The only solution is to adjust the column width manually for every single column, but this is tedious and time consuming and any new values will get auto-sized to fit the header text on 1 row regardless of settings.  The headers are descriptive text, in one example class names which can be upto 255 characters including a combination of codes, numbers, text and symbols.  This makes using UNICHAR(10) with delimiters to create multi-line headers not a viable solution.