Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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}})
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.
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.
User | Count |
---|---|
136 | |
73 | |
73 | |
58 | |
54 |
User | Count |
---|---|
194 | |
95 | |
63 | |
63 | |
51 |