UNICODE DAX Function (Text)

Syntax  |  Return values  |  Remarks  |  Examples  |  Articles  |  Related  

Returns the number (code point) corresponding to the first character of the text.

Syntax

UNICODE ( <Text> )

Parameter	Attributes	Description
Text		Text is the character for which you want the Unicode value.

Return values

Scalar A single integer value.

A numeric code for the first character in a text string.

Remarks

The Unicode encoding used by DAX is UTF-16.

» 1 related article
» 1 related function

Examples

--  UNICHAR returns a character given the unicode value.
--  UNICODE returns the Unicode value for a character
--      The example uses UNICODE ( "━" ) = 9473
EVALUATE 
{ 
    ( "UNICODE ( ""━"" )", UNICODE ( "━" ) ), 
    ("UNICHAR ( 9473 )",   UNICHAR ( 9473 ) ) 
}

EVALUATE
ADDCOLUMNS (
    VALUES ( 'Product'[Color] ),
    "Histogram", REPT ( UNICHAR ( 9473 ), [Sales Amount] / 1000000 )
)

Value1	Value2
UNICODE ( “━” )	9473
UNICHAR ( 9473 )	━

Color	Histogram
Silver	━━━━━━━
Blue	━━
White	━━━━━━
Red	━
Black	━━━━━━
Green	━
Orange	━
Pink	━
Yellow
Purple
Brown	━
Grey	━━━━
Gold
Azure
Silver Grey
Transparent

Related articles

Learn more about UNICODE in the following articles:

• Improving data labels with format strings

  This article describes the different approaches to format your DAX measures in Power BI semantic models using format custom and dynamic format strings. » Read more

Related functions

Other related functions are:

• UNICHAR

Last update: Dec 4, 2024   » Contribute   » Show contributors

Contributors: Alberto Ferrari, Marco Russo, Kenneth Barber

Microsoft documentation: https://docs.microsoft.com/en-us/dax/unicode-function-dax