Creating Formatted Text for Display in Text Visual

[Johnnyg]

I am trying to consolidate several fields into a formatted field with the intent to utilize less real-estate in my report.

In Query Editor, I have created a custom with the intent to have formatted text in the fields - to display the field "as is" in a text visual.  I am not maintaining the format after the query is applied.  (I am wondering if I am doing this the wrong way)

The custom column is built from all columns of Text type - using the followng statement:
FullAddress = [Name] & "#(lf)" & [Address] & "#(lf)" & [City] & ", " & [State] & "  " & [Zip] & "#(lf)" & [Phone]
 
The column's values would be formated text (like Excel does it).  Resulting in a formatted field in the custom column (FullAddress) as such:
John P. Jones
1121 S Andrews St
Faraway, NM, 09876
(123) 456-7890
 
Then, by using using a text visual (long text), I can list the Full Address (formatted as above) WYSIWYG
 
The format shows in the custom column (FullAddress), but when the query is applied the format is lost.

What am I doing wrong?  Or, is there a better approach?

[Greg_Deckler · Accepted solution]

Supposedly <br> is supposed to work although I haven't ever tried it after this thread (2nd page):

http://community.powerbi.com/t5/Desktop/New-line-Characters/m-p/37634#M13812

[Johnnyg]

Thank you, smoupre!!!  I will follow that thread.  I believe this is a reported issue, and the PowerBI team is working on a solution.

Cheers!

[nilkaush]

Is anyone able to get past this issue. I have started looking at long text viewer, however that does not solve the problem of adding new line character at the place required. Long text viewer is not providing control to add new line character. it just provides support for wordwrap.

[Brian_M]

Hi, I am using Long Text Viewer (Beta .2) with 'Newline starts with' option under the Format pane under Text...  It allows me use any delimiter I choose (note case sensitive) to denote a line break.  @nilkaush see if you can find those options in the Format pane?

[Greg_Deckler]

This has come up before and there was some guidance from the Power BI team at the time on what character to use as a line feed. However, it didn't work at that time and I think they might have filed it as a bug to be fixed. Let me see if I can dredge up the old thread.