How to Go to Next Line in Measure Power BI

Ever create a measure in Power BI that concatenates text, only to have it show up as one long, hard-to-read line in your report? Adding a simple line break can transform a jumbled text block into a clear, professional-looking summary. This article will show you the exact DAX functions and techniques you need to add new lines within your Power BI measures, making your cards, tables, and tooltips much easier to digest.

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 Bother with Line Breaks in Your DAX Measures?

Before jumping into the "how," let's quickly cover the "why." Properly formatting text inside a measure isn’t just about aesthetics, it’s about clarity. When you combine several pieces of information - like total sales, profit margin, and user count - into a single visual, you want each data point to stand on its own.

Line breaks allow you to:

• Create clean, readable KPI summary cards.
• Build dynamic titles that stack information vertically.
• Develop rich, informative tooltips that are properly formatted.
• Present multiple data points within a single table or matrix cell.

Instead of showing a card that reads "Total Sales: $540,231 Total Profit: $112,987 Units Sold: 4,321," you can present it clearly:

Total Sales: $540,231 Total Profit: $112,987 Units Sold: 4,321

This small change makes a huge difference in how users interpret your data. Let's look at the best ways to achieve this.

Method 1: Using UNICHAR(10) - The Go-To Solution

The most reliable and versatile way to create a line break in DAX is with the UNICHAR(10) function. This function returns the Unicode character that corresponds to a number. The number 10 specifically represents the "line feed" character, which is exactly what Power BI needs to start a new line.

Think of UNICHAR(10) as the DAX equivalent of pressing the "Enter" key on your keyboard.

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

Step-by-Step Guide to Using UNICHAR(10)

Let's build a simple summary measure that displays total sales and total profit, each on its own line.

1. Create a New Measure

In your report, navigate to the table where you want to store your measure, right-click, and select "New measure."

2. Write the DAX Formula

We'll combine text strings, our existing measures (like [Total Sales] and [Total Profit]), and the UNICHAR(10) function using the ampersand (&) symbol for concatenation.

It's good practice to use variables (VAR) to keep the code clean and easier to read. We will also use the FORMAT function to ensure our numbers look correct (e.g., adding currency symbols and commas).

KPI Card = VAR TotalSales = FORMAT( [Total Sales], "$#,##0" ) VAR TotalProfit = FORMAT( [Total Profit], "$#,##0" ) RETURN "Sales: " & TotalSales & UNICHAR(10) & "Profit: " & TotalProfit

Here's what the code does:

• VAR TotalSales: Stores the formatted Total Sales value in a variable.
• VAR TotalProfit: Stores the formatted Total Profit value in a variable.
• RETURN: This section constructs a single text string by combining everything.
• & UNICHAR(10) &: This is the key part that inserts a line break between the sales line and the profit line.

3. Add the Measure to a Visual (e.g., a Card)

Drag your new "KPI Card" measure onto your report canvas. It will likely create a Card visual automatically.

4. Enable Word Wrap (The Most Important Step!)

If you add the measure and still see everything on one line, don't worry! This is the most common pitfall. For the line break to appear, you must enable word wrapping on the visual itself.

• Select the Card visual.
• Go to the Format your visual pane (the paintbrush icon).
• Find the Callout value section.
• Toggle the Word wrap option to "On".

Voila! Your card should now display the sales and profit figures on separate, neatly formatted lines.

Method 2: Pressing Shift + Enter in the DAX Editor

For very simple text strings where you are not dynamically combining measures, there is an even quicker way to add a line break. Power BI's DAX editor recognizes manual line breaks entered into a text literal.

To use this method, simply press Shift + Enter while typing inside a text string (inside the quotation marks).

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:

Let's say you're creating a simple label for a visual.

Visual Label = "Quarterly Business Review Data for Q3"

When you create this measure and add it to a card (with word wrap enabled), it will render "Quarterly Business Review" and "Data for Q3" on separate lines.

When to use this method: This is excellent for static text labels. However, for anything dynamic that stitches together different measures or column values, the UNICHAR(10) method is far more powerful and manageable.

Advanced Use Case: Creating a Dynamic List with CONCATENATEX

Now, let’s combine our knowledge to solve a more complex problem. Imagine you want to display a list of the top 3 selling product categories in a single text visual, with each category on a new line.

The CONCATENATEX function is perfect for this. It iterates through a table, performs an expression for each row, and joins the results into a single string with a specified delimiter. We will use UNICHAR(10) as our delimiter!

Example DAX formula:

Top 3 Category List = "Top 3 Selling Categories:" & UNICHAR(10) & CONCATENATEX ( TOPN ( 3, VALUES ( 'Product'[Category] ), [Total Sales], DESC ), 'Product'[Category], UNICHAR(10) )

Breaking down this formula:

• TOPN(...): First, this function creates a virtual table of the top 3 product categories based on the [Total Sales] measure.
• CONCATENATEX(...): Then, this function takes that 3-row table and performs two main actions:

When you add this measure to a card visual with word wrap on, you'll get a beautifully formatted dynamic list that automatically updates as your data changes.

Troubleshooting Common Issues

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

1. The Line Break Isn’t Showing Up

As mentioned before, this is almost always because Word Wrap is turned off for the visual. Double-check the formatting pane:

• For a Card: Visualizations > Format visual > Callout value > Word wrap.
• For a Table: Visualizations > Format visual > Values > Word wrap (and for headers as needed).
• For a Matrix: Check format options under Values, Row headers, and Column headers.

2. My Numbers and Dates Are Wrongly Formatted

When you combine a number or date measure with a text string using &, Power BI converts it to raw text without its original formatting. For example, $1,234.50 might become 1234.5, or a date might turn into a number like 45305.00.

Solution: Always wrap your numeric or date measures in the FORMAT function when concatenating. Examples:

• Currency: FORMAT([Total Sales], "$#,##0.00")
• Dates: FORMAT(TODAY(), "mmm d, yyyy")
• Percentages: FORMAT([Profit Margin], "0.0%")

3. UNICHAR(10) vs. UNICHAR(13)

Some references mention UNICHAR(13) for "carriage return." In modern Power BI applications, you only need UNICHAR(10). Using both can cause extra spacing or formatting issues.

Final Thoughts

Knowing how to add line breaks within a DAX measure using UNICHAR(10) is a simple trick that can dramatically elevate the quality of your Power BI reports. It cleans up your visuals, improves readability, and allows you to present richer, more contextual data without cluttering your canvas with dozens of individual visuals.

Building dashboards often means spending hours manipulating DAX, adjusting visual settings, and wrestling with formatting options to get things just right. We’ve found that many teams spend more time manually wrangling their reports than actually acting on the insights. That's why we created Graphed, which eliminates this tedious work altogether. By connecting your data sources and describing what you want in plain English, you can have functional, real-time dashboards created in seconds, letting you skip the manual formula-writing and focus on getting answers from your data.