separate lines in column data being mashed together when put into table

[FatBlackCat30]

Hello all,

I have a column in Power BI called current entry. The data looks like this:

[Currententry]

Date: 1/17/2020

Subject: Snow

Text: Snow is great  

I formatted the data to pull line by line in SQL so all the entries come in like that. 

the problem is: when I drop [currententry] into the 'Table' visual all the data is being concatnated like this:

Date: 1/17/2020 Subject: Snow Text: Snow is great 

is there a way to get the data to show like this using a table?

Date: 1/17/2020

Subject: Snow

Text: Snow is great  

thank you

[VasTg]

It would be easier to add line break in SQL and Power BI will automatically render the data in next line.

@FatBlackCat30

[FatBlackCat30]

thats what I did, I added a line break in SQL and power bi is not rendering the data in the next line

[VasTg · Accepted solution]

@FatBlackCat30 

It works for me. See the query editor window for first 3 rows

The other option is to bring them as individual columns and concatenate them with UNICHAR(10) in DAX.

Refer to this post.

https://community.powerbi.com/t5/Desktop/Carriage-Return-in-Text-String/m-p/33388#M11829

If this helps, mark it as a solution.

Kudos are nice too

[FatBlackCat30]

I guess I wasnt super clear, sorry.

so it shows in the the query editor correctly (like in your example)

the problem happens when you add that data to a table, when you add it to a table the data is concatnated again.

so add your column1 to a table visual and see what I mean

[VasTg]

@FatBlackCat30 

No issues there as well.

[FatBlackCat30]

is there any settings that could be causing it to concatnate for me? 

[FatBlackCat30]

what the heak! I have no idea why it wont work for me