Home » Power BI » How to use unicode character/ emoji symbols in Power BI

How to use unicode character/ emoji symbols in Power BI

emoji Power bi

In this blog you will understand how you can add unicode character/ Emoji symbols in Power BI report based on conditions.

Sample Dataset

Just have a look below given sample data, here we have some feedback like – good, Bad & Poor.

ID feedback
1 Good
2 Poor
3 Bad
4 Good
5 Bad




As you can see below given screen shot, here we have some unicode emoji symbols, and against each symbols their Unicode number are mentioned.

So you can use that number with UNICHAR Dax function to display the unicode character/ Emoji symbols into Power BI report.

unicode symbols

unicode symbols

Let’s get started-

Now add one new column in your table and write below dax function-

Emoji_ =
IF(Feedback[feedback]="Good", UNICHAR(128512),
IF( Feedback[feedback]="BAD", UNICHAR(128530), 
UNICHAR(128557) 
) )

See the Output-

Symbols in Power BI

Symbols in Power BI



Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our contact form , we will revert to you asap.

Leave a Reply