Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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,
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.