Forum Discussion
Table Visual multiline column won't resize height automatically unless in first 20 columns
Hi Jojo197
Thanks for the reply from Uzi2019 .
First, please let me confirm with you whether your problem is as follows:
"the text has specifically been designed as multiline with the CHAR(10) character", are you using char(10) as the line break character?
In my test, I used UNICHAR(10) as the line break character to create a column after column 20.
When I adjust the height of the columns after column 20, if the height of the previous columns is smaller than that column, that column will not display the full text.
If the height of the first 20 columns is greater than this column, they will display normally.
It is mentioned in the official documentation that Power BI calculates the maximum cell size for a table based on the contents of the first 20 columns and the first 50 rows. Content in cells beyond those table dimensions might not be appropriately sized. So my suggestion is that you can adjust the height of the first 20 columns appropriately first, and then adjust the subsequent columns.
Best Regards,
Yulia XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Uzi2019 ,
I would share the file, but still trying to get around the organisation policy 😔
I have set up a sample demonstrating the issue with Columns A1 to Z26 and a multiline Test column in blue
Resizing only happens when the blue column is in the first 20 columns
Hope that makes it clearer
Thanks!
Hi Jojo197
I have checked. Initially if I add a value but it seems blank of differet level.
even though column have a very big text still consuming a small space to represent the blank text. As soon as I hit the column header for sorting I got the entire text all together in single line.
I got the entire text in single row without multi line formatting.
As you can see as long as my Text wrap is on and I limit my column size then I will get the multi line column for start of 20 column automatically.
same for column after 20th column.
You can check the screenshot.
One suggestion always make sure once you resize your column width make sure to turn off and again turn on the wrap text.
I hope this might help you.
Hi Uzi2019 ,
The difference with my columns are that the text has specifically been designed as multiline with the CHAR(10) character, which I think is different to yours. Text wrap does not work in this case
Thanks
Hi Jojo197
Thanks for the reply from Uzi2019 .
First, please let me confirm with you whether your problem is as follows:
"the text has specifically been designed as multiline with the CHAR(10) character", are you using char(10) as the line break character?
In my test, I used UNICHAR(10) as the line break character to create a column after column 20.
When I adjust the height of the columns after column 20, if the height of the previous columns is smaller than that column, that column will not display the full text.
If the height of the first 20 columns is greater than this column, they will display normally.
It is mentioned in the official documentation that Power BI calculates the maximum cell size for a table based on the contents of the first 20 columns and the first 50 rows. Content in cells beyond those table dimensions might not be appropriately sized. So my suggestion is that you can adjust the height of the first 20 columns appropriately first, and then adjust the subsequent columns.
Best Regards,
Yulia XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.