Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Dear community,
My data resource is from excel files from sharepoint folder, and there is one text column, it has 2 lines , how can I convert it into 1 line in each coloumn? The line breaks is blocking Text Filter Search function.
Best regards,
Clara Wang
Solved! Go to Solution.
I have figured it out! Add Column ->Format -> "Clean" and then line breaks were removed, it is 1 line text now.
I have figured it out! Add Column ->Format -> "Clean" and then line breaks were removed, it is 1 line text now.
Hello @clarawang_12 ,
You should use extraxt text after delimeter. Refer to this link for instructions https://radacad.com/extract-parts-of-a-text-value-in-power-bi-using-a-delimiter-power-query-transfor...
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! | |
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |