UNICODE DAX Function (Text)
Returns the number (code point) corresponding to the first character of the text.
Syntax
Parameter | Attributes | Description |
---|---|---|
Text |
Text is the character for which you want the Unicode value. |
Return values
A numeric code for the first character in a text string.
Remarks
The Unicode encoding used by DAX is UTF-16.
» 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:
Last update: Nov 7, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Kenneth Barber
Microsoft documentation: https://docs.microsoft.com/en-us/dax/unicode-function-dax