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! | |
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
88 | |
85 | |
68 | |
68 | |
64 |
User | Count |
---|---|
210 | |
118 | |
116 | |
81 | |
74 |