Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to 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
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
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
72 | |
38 | |
30 | |
26 |