Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.