Table visual format issue

[YashikaAgrawal]

Hi,

I have the table visual, as showin in the diagram.

If column1 value is single line, for column2 should also be in single line.

If column1 value is double lines, for column2 should also be in double lines.

Can we do like this.

Thanks,

[RicardoTraNa]

Hi! Yes in Power BI you can achieve this behavior using formatting settings, but not with a direct rule between columns.

Enable Word wrap for both columns and turn on Auto row height in the table visual. The row height will then expand based on the tallest cell, so if Column1 shows two lines, Column2 will have the same row height as well.

There is no built-in feature to force Column2 to match the exact number of lines of Column1...it works at row level, not per column.

Best regards! 

[NattyM]

Hi @YashikaAgrawal  , PBI doesn't let you control the height of the cell in the table visual based on the size of the values in the cells . 

If you want to force it , if its fine for you to trucate the value of column 2 based on column 1 then you can create a calculated measure that reads the length of column 1 and truncates the value of the column 2 and you can have your width and height as fixed in the visual .

This could be a workarround if you really want this functionality . but its recommended to truncate any data in the bi layer

[cengizhanarslan · Accepted solution]

No, Power BI Table visual can’t dynamically sync row height per column based on “number of wrapped lines”.

Row height in a Table is determined by the cell that needs the most height in that row (because of word wrap), but you cannot force “Column2 should use exactly the same number of lines as Column1” when Column2 text is shorter. Power BI won’t insert blank line breaks to “match” another column.