How to Go to Next Line in Power BI DAX

Adding a simple line break in a Power BI report seems like it should be easy, but it often stumps new and even intermediate users. DAX, the formula language of Power BI, doesn't have a straightforward "Enter" key equivalent. This article will show you the exact functions and techniques needed to add new lines to your DAX measures, transforming your cluttered visuals into clean, readable reports.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Are Line Breaks Important in Power BI?

Before jumping into the "how," let's cover the "why." Proper formatting is the difference between a confusing report and a compelling one. Line breaks are a small but powerful formatting tool that significantly improves the user experience in several key areas:

• Cleaner Card Visuals: Instead of cramming text and a number onto one line, you can create a title on the first line and display the KPI value on the second, making it much easier to read at a glance.
• Informative Tooltips: You can create custom tooltips that show multiple pieces of related information neatly stacked, providing context without cluttering the main chart.
• Dynamic, Multi-line Titles: Make your chart titles more descriptive by presenting key information, like the selected filter and the resulting metric, on separate lines.
• Readable Table and Matrix Cells: Combine multiple data fields into a single column with clear separation, like showing a customer's name and their address below it.

Once you learn this simple technique, you'll see opportunities to use it everywhere to make your reports more professional and user-friendly.

The Essential DAX Functions for Line Breaks

To create a new line in DAX, you need to combine two concepts: a way to specify a "line break character" and a way to join it with your other text and values.

The Key to a New Line: UNICHAR(10)

In many programming languages, you might use a special sequence like \n to represent a new line. DAX handles this differently, using the UNICHAR() function.

The UNICHAR() function returns the Unicode character that corresponds to a given number. The specific character code for a line feed (which Power BI interprets as a new line) is 10.

So, the magic formula you need to remember is:

UNICHAR(10)

Whenever Power BI sees this in a string of text, it knows to break to the next line.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Joining Text Together: The Ampersand (&)

Now that you know how to create the line break character, you need a way to combine it with your actual text and data. The easiest and most common way to do this in DAX is with the ampersand (&) operator. The ampersand joins, or "concatenates," two text strings together.

For example, you could combine a first and last name like this:

"John " & "Doe" // Returns "John Doe"

By combining the ampersand and UNICHAR(10), you can build your multi-line text strings.

"First Line" & UNICHAR(10) & "Second Line"

This formula will produce text that looks like this in a supported Power BI visual:

First Line Second Line

Practical Examples: Adding Line Breaks in Your Reports

Let's walk through a few common scenarios where adding a line break is incredibly useful.

Example 1: A Multi-Line Card Visual

A simple card visual is great for showcasing a single KPI, but it's even better with a descriptive title. Let's create a measure that shows "Total Sales:" on one line and the formatted sales amount on the next.

Assume you already have a basic measure for total sales, like Total Sales = SUM(Sales[Revenue]).

1. Create a new measure.
2. Enter the following DAX formula:

Sales Card with Title = "Total Sales:" & UNICHAR(10) & FORMAT([Total Sales], "$#,##0")

1. Drag this new measure into a Card visual on your report canvas.

Formula Breakdown:

• "Total Sales:" is the text for our first line.
• & UNICHAR(10) & adds the line break.
• FORMAT([Total Sales], "$#,##0") takes our existing sales measure and formats it as currency with a comma separator, making it easy to read.

The result is a clean, self-explanatory card that is far more effective than just showing a number.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Example 2: Creating a Detailed Tooltip

Tooltips are perfect for providing extra context when a user hovers over a data point without cluttering the visual. Let's build a tooltip for a sales chart that shows total sales, profit, and profit margin, all neatly stacked.

Assume you have measures for [Total Sales], [Total Profit], and [Profit Margin].

1. Create a new measure for the tooltip text.
2. Enter this formula:

Sales Details Tooltip = "Sales: " & FORMAT([Total Sales], "Currency") & UNICHAR(10) & "Profit: " & FORMAT([Total Profit], "Currency") & UNICHAR(10) & "Profit Margin: " & FORMAT([Profit Margin], "0.0%")

1. Now, select the visual (e.g., a clustered bar chart) where you want this tooltip to appear.
2. Go to the Format visual pane (the paintbrush icon).
3. Expand the General tab, then turn on the Tooltips option. Make sure the type is set to "Report page" and choose "Auto."
4. Go to the Build a visual pane (the bar chart icon).
5. Drag your newly created [Sales Details Tooltip] measure into the Tooltips data field well.

Now, when you hover over a bar in your chart, instead of the default tooltip, you will see your custom, perfectly formatted, multi-line summary.

Example 3: Line Breaks in Tables and Matrices (and How to Fix Them)

You can also use this technique in a calculated column to combine data within a table. For instance, let’s combine a product name with its category on a new line.

1. Navigate to the Data view and select your Products table.
2. Click on New column.
3. Enter the DAX formula:

Product & Category = Products[Product Name] & UNICHAR(10) & "(" & Products[Category] & ")"

When you drag this new column into a table or matrix visual, you might notice something frustrating: the line break doesn't show up! The text appears all on one line.

This is the most common issue users face with line breaks, but the fix is simple.

How to Enable Word Wrap in Tables

1. Select your table or matrix visual.
2. Go to the Format visual pane.
3. Go to the Values section (for a Matrix, you'll find this under Values or Row headers, depending on where you placed the field).
4. Find the Word wrap toggle and turn it On.

Instantly, your line breaks will appear correctly, and the cell content will be formatted as intended.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Bonus Tip: Use Variables for Cleaner Code

As your formulas get more complex (like our tooltip example), chaining together many ampersands can make your code difficult to read and debug. This is where DAX variables come in handy.

You can rewrite the tooltip measure using variables to make it much cleaner.

Sales Details Tooltip (Clean) = VAR Line1 = "Sales: " & FORMAT([Total Sales], "Currency") VAR Line2 = "Profit: " & FORMAT([Total Profit], "Currency") VAR Line3 = "Profit Margin: " & FORMAT([Profit Margin], "0.0%") VAR NewLine = UNICHAR(10) RETURN Line1 & NewLine & Line2 & NewLine & Line3

This code produces the exact same result, but it's significantly easier to understand. Each line of the tooltip is defined separately, and we even create a variable for UNICHAR(10). The final RETURN statement then assembles all the pieces. Using this structure for complex text measures is a best practice that will save you headaches later on.

Final Thoughts

Mastering the UNICHAR(10) function, combined with the ampersand operator, is a fundamental Power BI skill that elevates the quality and clarity of your reports. It’s a simple trick that moves your visuals beyond basic functionality into the realm of professional dashboard design where user experience is prioritized.

Learning the specific syntax for DAX calculations and navigating formatting panes is part of the territory with complex tools like Power BI. At Graphed, we’ve built an experience that lets you skip this entire process. Instead of writing formulas or hunting for the word wrap toggle, you can just ask in plain English: "Show me a chart comparing sales and profit margin by product category." We connect to your data and build the dashboard instantly, handling all the formatting and analysis for you, turning hours of report building into a 30-second task.