DAX Function Guide

UNICHAR
Empty image or helper icon

Sam McKay

CEO & Founder

How does the UNICHAR 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?

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

Loading

Considerations when using the UNICHAR?

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

Loading

Formula examples using the UNICHAR
=UNICHAR(65)
Related Courses

Loading