Power BI DAX FORMAT Function

FORMAT function helps us display dates, numbers, currency values and percentages in the format we want. It is particularly useful when displaying dates, numbers, currency values, and percentages in a readable format in Power BI reports and dashboards.

Syntax:

FORMAT(Value, Format_String, [Locale_Name])
Note:
Value: The column or measure that we want to format.
Format_String: The format we want to apply.
Locale_Name: An optional parameter that specifies the language and regional formatting.

Note: FORMAT converts the result into text.

Basic example:

Formatted Order Date =
FORMAT(
    FactInternetSales[OrderDate],
    "dd-MM-yyyy"
)

For example, a date of 30 October 2026 will be displayed as 30-10-2026

Date format table

Note: Short date formats and localized names can vary according to the locale setting.

Example:

Formatted Order date =
FORMAT(
    FactInternetSales[OrderDate],
    "MMM yyyy"
)

Time Formatting in DAX

DAX FORMAT – Time Format Strings

Number Formatting in DAX

The FORMAT function supports different number formats, including integers, decimal numbers, percentages and scientific notation.

Complete number format table

Example:

Sales With Decimal =
FORMAT(
    [Total Sales],
    "#,##0.00"
)

Currency Formatting in DAX

FORMAT can display values with currency symbols.

Complete currency format table

Example:

Sales USD =
FORMAT(
    [Total Sales],
    "$#,##0.00"
)

Common locale codes