Forum Discussion

Amos_Lim's avatar
Amos_Lim
Icon for Resolver I rankResolver I
2 years ago

How to move the line up

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}})

 

 

 

4 Replies

    • Amos_Lim's avatar
      Amos_Lim
      Icon for Resolver I rankResolver I

      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's avatar
        mlsx4
        Icon for Memorable Member rankMemorable Member

        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.