DAX Expression: Need Multiple Space Line Breaks for use in Matrix Visual

[Anonymous]

Hi All,

I am able to apply one line break to my DAX expression to allow for new text start. However, the matrix visual that I will end up using doesn't really allow padding on the start of multiple rows (as if it is single spaced). The card and enlighten data story visuals won't work because either I can not enable word wrap and/or the visual doesn't respect the orginial link break from the DAX code.

My current DAX code

CONCATENATE(" Real Demand Chair: ",[RealDemandChairNotes])

& UNICHAR(10) &

CONCATENATE(" Real Demand Lamp: ",[RealDemandLampNotes])

& UNICHAR(10) &

CONCATENATE(" Real Demand Table ",[RealDemandTableNotes])

My current output: (with Matrix Visual)

Real Demand Chair: Real Demand Output is

Real Demand Lamp: Real Demand Output is

Real Demand Table: Real Deamnd Output is

My Desired Output:

Real Demand Chair: Real Demand Output is

Real Demand Lamp: Real Demand Output is

Real Demand Table: Real Deamnd Output is

Thanks in advance for any help! I will continue to try to see if I can get it!

[edhans · Accepted solution]

have you thought of adding the non-breaking space after the unicode line feed? It is 160.

[Anonymous]

Thanks @edhans - this worked!

Also, I was able to find another solution by simply adding another "UNICHAR(10) &" for a double line break.

Thanks!

Aaron

[mbahonen]

I know this thread is old, but in case anyone sees this... Did this actually work for you? I've added two UNICHAR(10) in my text and it does nothing. Were you using all text in the DAX or were your line breaks between other measures? 

[jonasdueholm]

UNICHAR(10)&UNICHAR(160)&UNICHAR(10) worked for me

[edhans]

Great @Anonymous - often more than one way to get the results you need! 😁