Is there a way to add line breaks in a string of text in Microsoft's DAX language?

line-breaks dax powerbi
jschlereth picture jschlereth · Mar 10, 2016 · Viewed 21.8k times · Source

I have a DAX function that pulls in multiple strings of text (from multiple columns) into one cell. But on display I want to have a line break in between the header and the body of the paragraph. Is there a way to code in a line break with DAX? FYI, I'm using Power BI for this. Thanks!

Answer

nguyen giang picture nguyen giang · Jul 23, 2016

In BI Desktop, just type alt-enter in your DAX formula to add new line For example: 

CONCATENATEX(Project, ProjectName & ":" & [some-measure], 
//new line in parameter delimiter
",
"
)

Related questions

How do I specify new lines on Python, when writing on files?

In comparison to Java (in a string), you would do something like "First Line\r\nSecond Line". So how would you do that in Python, for purposes of writing multiple lines to a regular file?

Read More
How can I do a line break (line continuation) in Python?

I have a long line of code that I want to break up among multiple lines. What do I use and what is the syntax? For example, adding a bunch of strings, e = 'a' + 'b' + 'c' + 'd' and have it …

Read More
Difference between CR LF, LF and CR line break types?

I'd like to know the difference (with examples if possible) between CR LF (Windows), LF (Unix) and CR (Macintosh) line break types.

Read More