The UNICHAR function returns the Unicode character corresponding to the indicated "code point".
UNICHAR(
number
)
- number: Unicode numeric code corresponding to the character to be obtained.
The UNICHAR function returns a text string.
If the indicated code does not have a Unicode correspondence or if the code is zero, the function returns an error.
The result returned by the function can be a character string, for example in UTF-8 or UTF-16 format.
This example adds a calculated column that displays the character corresponding to the number in the Unicode[Código] column:
Carácter = UNICHAR('Unicode'[Código])
In this second example we are creating a measure that concatenates a text and the numeric value returned by another measure:
Ventas = CONCATENATE("Ventas totales: ", FORMAT([Sales], "Currency"))
If we take this measure [Ventas] to a card-type display, the result is the following:
Now, if we add the UNICHAR(10) character to the text "Ventas totales: " of the previous measure, we are forcing a line break:
Ventas = CONCATENATE("Ventas totales: " & UNICHAR(10), FORMAT([Sales], "Currency"))