Downloads
DAXTextBeginner

FORMAT

Converts a value to text using a format pattern such as currency, percent or date.

Syntax
FORMAT(<value>, <format_string> [, <locale_name>])

Returns: Text (a scalar).

What it does

FORMAT turns a number or a date into text in the shape you describe, such as "$1,234", "12.5%" or "Mar 2026". It is useful for titles, labels and tooltips that must include a value. The result is text, so it cannot be summed, sorted as a number or used in a calculation. For the number that a chart or a card shows, set the format in the measure, not with FORMAT.

Syntax and arguments

Example

The dashboard title should state the period in words and show the total sales in dollars, so a printed page is clear without the slicers.

Dashboard Title =
"Sales for " & FORMAT(MAX('Date'[Date]), "MMMM yyyy")
    & ", total " & FORMAT([Total Sales], "$#,0")

If the latest date in the filter is in March 2026, the title reads "Sales for March 2026" followed by the total in whole dollars. The title updates when the slicer changes.

Example: a second, different use

A tooltip that shows the margin percentage with one decimal place and a word label:

Margin Tooltip = "Margin " & FORMAT([Gross Margin %], "0.0%")

The percentage is rounded for display only. The measure keeps its full value for other calculations.

Things to watch

In business terms

FORMAT builds the titles, footnotes and commentary text in finance packs: the period covered, the amount reported, the variance in percent. It keeps the words of a report in step with the numbers when the filters change.

Related functions

All DAX functions · View as Markdown · DAX fundamentals