How to move the line up

[Amos_Lim]

How can I remove the spacing highlighted in "yellow" colour as per the photo.

I am using the code

= Table.Group(#"Filtered Rows2", {"User name","CAN ID","Section"}, {{"KeyTags", each Text.Combine([keyTags],"#(lf)"), type nullable text}})

[mlsx4]

Hi @Amos_Lim 

You can remove it by replacing in this way

[Amos_Lim]

It only works with User Names and does not work for KeyTags.

How can I display the full text in the dashboard if I accept the result shown in the second photo? Because I am unable to adjust the height of the row to display the text completely.

[mlsx4]

Hi @Amos_Lim 

It may not work if the special character is different. Don't know if you have tried another char like carriage-return "#(cr)".

And regarding your second question, I don't understand your need.

[Amos_Lim]

Thanks, mlsx4.

"#(cr)" will not work either.

In response to question 2, I meant that if the KeyTags column contains more information, the information will not be displayed in its entirety on the Power BI dashboard. After the last character, there will be "...."

I'm not sure if there is a workaround.