Format Coding to stack inside cell

[ThePrasch]

Hey gang -

I have, what I believe, is a unique ask. Has anyone come across a way to create custom formatting strings that will allow me to stack two different output values in a table on top of one another rather than forcing them to always go across and wrap around. Below is a picture of what I'm showing (a variance $ amount and its percentage in the same column), but I want to have it appear as $'s on top and the percentage below in every cell.

My formula simply takes 

IF(_Trd_View = "Both ($ & %)", FORMAT(_ProperValue,[Format_Coding]) &" ["& FORMAT(_Value_Pctg,"+0.0%;-0.0%") &"]"

I want to know if there is something I can insert that forces a carriage return in the above formula and moves everything past the &" ["& to a new line within the same cell.

[ThePrasch · Accepted solution]

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

[v-chenwuz-msft]

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