Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
FatBlackCat30
Employee
Employee

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

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

1 ACCEPTED SOLUTION

@FatBlackCat30 

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

Cap11.PNG

 

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

 

Connect on LinkedIn

View solution in original post

7 REPLIES 7
VasTg
Memorable Member
Memorable Member

  

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

 

 

@FatBlackCat30

Connect on LinkedIn

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

@FatBlackCat30 

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

Cap11.PNG

 

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

 

Connect on LinkedIn

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

 

 

@FatBlackCat30 

 

No issues there as well.

 

Cap11.PNG

Connect on LinkedIn

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

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.