Line breaks not working in report view in Power BI

[FatBlackCat30]

Hello all,

I have some data in Power BI I loaded in from SQL. In the SQL query I added line breaks to get the date, note modified by, subject, and Note on individual lines. (see picture) .

Power Query

In Power Query the data is showing correctly, but when I add the column "Most Current Entry" to the table visualization the line breaks are no longer working (see picture)

is there a way to fix this/ why is this happening?

thank you !!

[az38 · Accepted solution]

Hi @FatBlackCat30 

Unfortunately, breaks from data source will not work in visuals, but there is a solution

if you replace breaks to any symbol like "|", and get the column value, for example, "string 1|string 2|string 3" you will be able to create a column that then replace "|" to breaks:

Column = SUBSTITUTE([ColumnWithBreaks];"|";UNICHAR(10))

do not hesitate to give a kudo to useful posts and mark solutions as solution

LinkedIn

[FatBlackCat30]

@az38  you are the man! worked perfectly 

thank you very much

[FatBlackCat30]

oh great! I will try that right now and let you know how it works. 

thank you for the input