The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Hi All,
How to write line break function in concate funcation. I tried with <br /> but it was not working
Can you please help on this.
Solved! Go to Solution.
Try using UNICHAR(10). For example: Column = "Line 1"& UNICHAR(10) & "Line 2".
And make sure you have the "Word Wrap" option activate on your Card/Table/Matrix/etc.
"Text Wrap" in Callout Value if you're using a card
In the concatenate code, if you insert a "shift + enter" after the comma, it gives me a line break, without breaking the code.
Hi @Jim123456789jim,
After research, please refer to the solution here. Please respond me if you have other issue.
Thanks,
Angelia
Try using UNICHAR(10). For example: Column = "Line 1"& UNICHAR(10) & "Line 2".
And make sure you have the "Word Wrap" option activate on your Card/Table/Matrix/etc.
User | Count |
---|---|
65 | |
61 | |
60 | |
53 | |
30 |
User | Count |
---|---|
181 | |
88 | |
71 | |
48 | |
46 |