Forum Discussion
Format Coding to stack inside cell
So - I managed to dig up the solution after posting this. I found one way is to insert a UNICHAR(##) into my concatenate statement and that forces enough continuous whitespace to push results to a new row in the cell.
The solution I found was in the following PBI community forum: https://community.powerbi.com/t5/Desktop/Carriage-Returns-concatenated-text/m-p/80527/highlight/true
So - I managed to dig up the solution after posting this. I found one way is to insert a UNICHAR(##) into my concatenate statement and that forces enough continuous whitespace to push results to a new row in the cell.
The solution I found was in the following PBI community forum: https://community.powerbi.com/t5/Desktop/Carriage-Returns-concatenated-text/m-p/80527/highlight/true
Hi ThePrasch ,
Glad your problem is solved, please mark it so that more people can find it. Or you can just insert a line break in the second half of the <format_string> by pressing the ALT+ ENTER key combination to achieve the line break.
Best Regards
Community Support Team _ chenwu zhu