TIP: Emoji In A DAX Formula?!

OK, how about this…

Pressing Windows+. in Windows 10 brings up an Emoji board. In a measure wrap your selected emoji in quotes to use in a report. i.e. Measure = “:birthday:

Could be used for some fun conditional icons in a report. If this then :pizza: else :beer:.

8 Likes

Thanks for sharing :slightly_smiling_face:

Great tip! This is the kind of thing that really amps up a reporting solution instead of just numbers and text.

I work with ASCII character codes all the time in T-SQL and also HTML special characters for web page display. The Dingbats font also helps with cool reporting features like a green checkmark. Emojis are just Unicode characters, so I went digging for even more info on how to work with Unicode emoji characters.

The following link has a full list of v13.0 Emoji characters with the Unicode values: https://unicode.org/emoji/charts/full-emoji-list.html#1f600

The following link explains how to convert Hex to Dec codes for use with the “&#…” format in HTML: https://www.w3schools.com/charsets/ref_emoji.asp

And the following link is a cool example of using an emoji Unicode character with UNICHAR([Dec Code]) in a DAX SWITCH statement to show the characters as measure-based indicators: https://community.powerbi.com/t5/Community-Blog/Power-BI-Desktop-DAX-Using-Unicode-Arrows-as-Measures-in-a-Table/ba-p/190725

John C. Pratt
Enterprise%20DNA%20Expert%20-%20Small

5 Likes

Hi @marcster_uk,

This is indeed a cool idea to be used and let me suggest you something that I use for this.

So there is a website named: getemoji

Here, the emojis are basically like texts, so you can just write you DAX formula and then, simply copy & paste the emojis and then, you will get what you need in a smooth manner.

Let me know your thoughts on this.

3 Likes

Nice, very cool link

1 Like

@quantumudit, that is a great link! I was even able to paste the emojis into Notepad on Windows with almost no degradation in quality. In an email or Word doc, they paste as displayed. Thanks!

John C. Pratt
Enterprise%20DNA%20Expert%20-%20Small

1 Like

Thats the beauty… I often used the site to use emojis on jupyter notebooks… Never used that in Power BI though but, yes… you can do that :smiley::smiley: Enjoy :heart: