UNICHAR function is a power BI DAX text function that returns Unicode character referenced by the numeric value.
number is a unicode number that represents the character, and returns an error, number is zero.
Lets look at an example of UNICHAR function
The following DAX measure RedColor returns the character represented by the Unicode number 128992 that is red color circle character.
RedColor = UNICHAR(128992)
Lets drag the measure to the card visual to see the output.
Lets look at an another example using dataset.
Here we have a sample dataset named Customerfeedback.
Which contains the customer names along with the ratings (out of 5) given by them for restaurant service.
Lets display the ratings in terms of visual like if customer has given 2 rating then display two star, if 5 then 5 star.
Following Dax measure uses the Dax function REPT, that repeats text a given number of times , for text we provide a UNICHAR Code number 11088 that returns the yellow star character.
Ratings = REPT(UNICHAR(11088), AVERAGE(CutomerFeedback[ServiceFeedback]) )
Lets use matrix visual to display the Customer and ratings given by them.
You can also use another unicode character to make your visual more interactive, You can get various unicode character symbol from website – URL
4,161 total views, 1 views today