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 post, you will learn how to add Unicode characters/emoji symbols to a Power BI report based on conditions.

Sample Dataset

Take a look at the sample data provided below; here, we have some feedback such as ‘good,’ ‘bad,’ and ‘poor.

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

Below, in the provided screenshot, you can observe several Unicode emoji symbols, each accompanied by its corresponding Unicode number.

You can utilize this number with the UNICHAR DAX function to showcase the Unicode characters/emoji symbols in your Power BI report.

unicode symbols

Unicode symbols

Let’s get started-

Now, add one new column to your table and write the following DAX function below it.

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

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