Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos
Catch up on one of our webinars
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
401 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
You can learn more about this topic on the following Wise Owl courses:
In a DAX formula, you can concatenate a new line character using the UNICHAR function with the character code 10.
In the example below, we're concatenating a new line between the title of a film, its release date and the name of its director in a calculated column:

Character number 10 corresponds to a line feed.
Here's the result displayed in a table visual:

Each detail appears on a new line.
If you don't want to use the UNICHAR function you can achieve the same result by typing a literal new line character between speech marks:

You can enter a new line in a DAX formula by pressing Shift and Enter.
You can use the same techniques in other functions, such as CONCATENATEX. The example below uses the CONCATENATEX function in a measure to insert a new line between each film title:

This creates a list of films sorted by release date.
We can display this measure in different visuals in a report.

We're displaying the measure in both a table and the tooltip of a column chart.
You can learn more about this topic on the following Wise Owl courses:
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Elementa Workspace
6 Bevis Marks
LONDON
EC3A 7BA
c/o Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2026. All Rights Reserved.