Did you know that you can use emojis in Power BI? If you’re like me, you probably had no idea this was possible. In this post, I’m going to show you 3 ways to add emojis to your report!

Method 1:

Hit the Windows Key + Period. If you’re on Windows 10, this opens up a dialog box showing you all of the possible emojis you have to choose from. You can even hit the magnifying glass in the bottom left and search for the emoji that fits your needs.

Method 2:

Copy and paste the emoji from the web directly into the Power BI formula bar. Simple enough, and it works.

Method 3:

Use the UNICHAR function. This is a built-in DAX function that takes unichar numeric codes and turns them into their visual representations. Simply feed a number to the UNICHAR function and you have your emojis 😊

In the example above, I am adding 128512 and my “Emoji” column to feed the UNICHAR function. For example, the first row results in UNICHAR(128512), the second row UNICHAR(128513), and so on.

I hope you enjoyed this quick trick on how to add emojis in Power BI! If you’re new here, make sure to subscribe to the BI Elite Blog and BI Elite YouTube channel for more Power BI, DAX, and PowerQuery tips and tricks!