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
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
Related Support Forum Posts
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
Formula examples using the UNICHAR function
Related DAX Functions
Related Course Modules
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.