Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi,
Does anyone know if we can add a carrage return and have it function in a text block in the visualization.
The goal
------------
Field_A & " - " & Field_B & Carrage Return & Field_C
Outcome
------------
Dog - Cat
Horse
Can't seem to find a thread where someone was successfull.
Cheers
Hi @svella , if you want the effect reported in the image below, you have to select "wrap text": ON in the visual card properties.
I used the DAX formula
Thanks,
g
Use #(lf) inside your quotations
Field_A & "#(lf)" & Field_B
Just reverse what you would do if you were splitting the column.
I have the same problem, I would like to add a "Carriage return" to concatenated text. Could you please let me know if/when you find a solution to the problem?
Many thanks,
add UNICHAR(10) into your text string... seems to work. can't find the thread i found that in!
UNICHAR(10) works but doesn't appear to do anything for the visual and also causes line breaks in a csv export.
Check that. If you turn on "Word wrap" in Values, it'll wrap those values in the table view according the break code. Nice.
In DAX, , you just need to use "Alt + Enter" to type "Carriage Return". However, "Carriage Return" can't be displayed in visual. It always appear in a line. You can see the actual field when you hover on the data field.
Column = Table2[NAME]& " " &Table2[id]
Regards,
Hi Simon,
Yes I use that technique for the code lines but I am looking for it to show visually. I assume at this point their isnt a way to
add one to appear in the visuals ?
thanks
Currently, it's not supported to display the Carriage Returns within cells in visual.
Regards,
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
67 | |
57 | |
54 | |
36 | |
34 |
User | Count |
---|---|
84 | |
71 | |
55 | |
45 | |
43 |