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.

https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-tables?tabs=powerbi-desktop#considerations-and-troubleshooting 

Best Regards,
Yulia Xu

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