Add Emoji to Conditional Formating Icon

[wujunmin]

How to Add Emoji to Conditional Formating Icon?

1. Get emoji

1) Get emoji by "Win+."

Then write a measure:

Emoji = IF([Rank]<=3,"😁","😟")

 

2) Get emoji by UNICHAR: 

UNICHAR = IF([RANK]<=3,UNICHAR(128513),UNICHAR(128577))

Here is an unicode list: https://unicode-table.com/en/emoji/

2.  Combine values with emoji

Emoji couldn't be added to conditional formating icon directly, because an emoji is a text. 

So you need to convert emoji into an image. How? 

Wrap Emoji into SVG: 

Emoji_SVG=

"data&colon;image/svg+xml;utf8,<svg xmlns='http://www.w3.org/2000/svg' width='48' height='48'>

<text x='24' y='26' text-anchor='middle' dominant-baseline='middle' font-size='40' fill='Tomato'>"

&IF([RANK]<=3,"😁","😟")&"

</text>

</svg>"

UNICHAR_SVG =

"data&colon;image/svg+xml;utf8,<svg xmlns='http://www.w3.org/2000/svg' width='48' height='48'>

<text x='24' y='26' text-anchor='middle' dominant-baseline='middle' font-size='40'>"

&IF([RANK]<=3,UNICHAR(128513),UNICHAR(128577))&"

</text>

</svg>"

Then, add the SVG emoji measure to conditional formating icon, you could get the result.