Table Visual multiline column won't resize height automatically unless in first 20 columns

[Jojo197]

Was very weird at first. One report would resize the height of a multiline column in a table visual automatically, so that all lines of text were visible.

In another dashboard, now with more columns. The same column will not resize unless it is moved to the first 20 columns in the table.

Have done some testing and being in the first 20 columns is the only way to get it to resize as far as I can tell. 

Is this a bug?

Thanks

[Jojo197]

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!

[Uzi2019]

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.

[Jojo197]

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

[v-xuxinyi-msft · Accepted solution]

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-deskto... 

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.

[Jojo197]

Thanks Yulia,
I had not seen that in the documentation previously - that answers my question

And yep, was UNICHAR(10) i was using, not CHAR(10) - my mistake.

[Uzi2019]

Hi @Jojo197 

Can you share the screenshot of your query??  Its better for us to understand with help of sample data.