UNICHAR Function (DAX)

How does the UNICHAR function (DAX) work?

UNICHAR function (DAX) it accepts an integer which maps the character that you want to show in your visual. The best way to find the character you want is to search such an online resource. https:/unicode.com/

UNICHAR Formula Syntax

UNICHAR (number)

How do you use the UNICHAR function?

One of the UNICHAR feature’s uses is to be able to display non-text characters within visuals. Useful visualizations can be generated by combining a logical collection of such codes (icon sets).

Related Blog Posts

Using-Filter-Fields-Visual-Interactions-To-Create-Compelling-Visualizations-In-Power-BI

Related Support Forum Posts

Data Visualization Tips – UNICHARS
Displaying Names in a Table
A good visual to show “less” is better

Considerations when using the UNICHAR function

Note at this time it is not possible to apply conditional color formatting to a measure that returns a text value

It is a good practice to avoid relying on visual colors that blind people cannot interpret. Here UNICHAR characters can help you to use both numbers color and a direction indicator icon.

If XML characters are not invalid, UNICHAR returns an error.

If Unicode numbers are partial surrogates and data types are not valid, UNICHAR returns an error.

If numbers are numeric values that fall outside the allowable range, UNICHAR returns an error.

If number is zero (0), UNICHAR returns an error.

The Unicode character returned can be a string of characters, for example in UTF-8 or UTF-16 codes.

Related Video Tutorials

EDNA TV-Unichar
Dynamically-Compare-Monthly-Information-Cumulatively-in-Power-BI-w-DAX-1

Formula examples using the UNICHAR function

=UNICHAR(65)

Related DAX Functions

ceiling
ROUND
ROUNDUP

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI

DOWNLOAD

To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.