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
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
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.