Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
have you thought of adding the non-breaking space after the unicode line feed? It is 160.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reportinghave you thought of adding the non-breaking space after the unicode line feed? It is 160.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThanks @edhans - this worked!
Also, I was able to find another solution by simply adding another "UNICHAR(10) &" for a double line break.
Thanks!
Aaron
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?
Great @Anonymous - often more than one way to get the results you need! 😁
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
19 | |
19 | |
16 | |
15 |
User | Count |
---|---|
49 | |
26 | |
22 | |
17 | |
16 |