Forum Discussion

YashikaAgrawal's avatar
YashikaAgrawal
Icon for Post Patron rankPost Patron
6 months ago
Solved

Table visual format issue

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 b...
Need Help
  • cengizhanarslan's avatar
    cengizhanarslan
    6 months ago

    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.

Natarajan_M's avatar
Natarajan_M
Icon for Super User rankSuper User
6 months ago

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