Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Amos_Lim
Resolver I
Resolver I

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

 

 

Capture.JPG

 

Sample1.jpg

4 REPLIES 4
mlsx4
Memorable Member
Memorable Member

Hi @Amos_Lim 

 

You can remove it by replacing in this way

mlsx4_0-1695192225411.png

 

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.

 

Sample1.jpgSample2.jpg

Sample2.jpg

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.

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.

 

Sample2.jpg

 

 

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.