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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
ThePrasch
Frequent Visitor

Format Coding to stack inside cell

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_0-1651243942922.png

 

1 ACCEPTED SOLUTION
ThePrasch
Frequent Visitor

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

 

View solution in original post

2 REPLIES 2
ThePrasch
Frequent Visitor

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.

vchenwuzmsft_0-1651543871925.png

 

Best Regards

Community Support Team _ chenwu zhu

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.