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
Center of Excellence

DOWNLOAD


Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.


Download DAX Formulas Reference Guide
Download DAX Formula Reference Guide
Membership