The Power BI UNICODE function is one of the DAX text functions helpful to return the Unicode (code point) number of the first character in a given string. This article explains the DAX UNICODE function that accepts the text and returns the numeric code point of the first string character and the syntax is shown below:
UNICODE(<text>)
Power BI DAX UNICODE function Example
To demonstrate the DAX UNICODE() function, click the New Column button in the Modeling Tab, and name as the CatCode. The below expression returns the Unicode (code point) number of the first character of the Category column in each row.
Please add the CatCode column to the table report. Next, click the down arrow to change the default aggregate value from Sum to Don’t Summarize option. Please refer to the String and the function article for the remaining Power BI methods. For more Charts >> Click Here.
CatCode = UNICODE(Orders[Category])
Similarly, we have created one more column to find the Unicode number of first characters in the product sub-category.
SubCode = UNICODE(Orders[Sub-Category])
