Forum Discussion
New line Characters
mork, please have a check on arify's solution to see whether it works. If you still need further help, please post back.
Hi Vicky_Song,
I don't think this issue has been resolved. If it has, could you direct me to the solution?
I need to display an address like this:
Line 1
Line 2
City
Postcode
Instead of this:
Line 1, Line 2, City, Postcode
Thanks!
- bschnabe9 years agoNew Member
I'm told this is available in the July 2017 release...
The Power BI Desktop July release has word wrap support e.g. Measure = "This is the first line" & UNICHAR(10) & "This is the second line". Make sure you turn on word wrap for the grid/title for the visualization. https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-july-feature-summary-2/
- dhawal168 years agoAdvocate I
Hi,
I know you asked this question on 2016, though if you are still looking for an answer. It should work from below
This will work considering you have seperate column for each. If that is not the case just replace (,) with #(cr)#(lf)
= Table.CombineColumns(Table.TransformColumnTypes(#"Source", {{"Line1", type text}, {"Line2", type text}, {"City", type text}, {"Postal Code", type text}},Combiner.CombineTextByDelimiter("#(cr)#(lf)", QuoteStyle.None),"Address")
Mark this as a Solution if this work.
Thanks,
Dhawal
- Sean9 years agoCommunity Champion
Has anyone had any luck implementing this in the Card Visual ???
- MarcelBeug9 years agoCommunity Champion
- KellyDittmar9 years agoAdvocate IV
Sean - did you have to do something special to make Unichar work? I keep getting stuck with an invalid syntax error - but I can't see what I'm doing wrong.