Reply
wujunmin
Advocate II
Advocate II
Partially syndicated - Outbound

How to use emoji in table and matrix?

Using emojis in Power BI is pretty cool and not too tricky. You can pop them up using  IME, or the UNICHAR function works great for showing them. And creating a measure for emojis? Piece of cake! 

 

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

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

 

But here’s the fun part – adding emojis to conditional formatting. You don’t want them just sitting in their own column, right?

 

1.png

So, here’s the deal with emojis: they’re like text. And in Power BI, text can’t be used as an icon in conditional formatting. But guess what? Images can! So, let’s get creative. We’ll just wrap those emojis in an SVG Text tag, turn them into nifty images, and then use them in our conditional formatting. 

 

Emoji_SVG1 =
"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([KPI]<=3,"😁","😟")&"
</text>
</svg>"

 

Emoji_SVG2=
"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([KPI]<=3,UNICHAR(128513),UNICHAR(128577))&"
</text>
</svg>"

1 ACCEPTED SOLUTION

Syndicated - Outbound

Hello @wujunmin , you will need to host the file on another cloud service (such as OneDrive, Google Drive, etc.) and anonymously share it using a sharing link as a reply to your original post.

 

Please take a moment to read over one of the cornerstone resources of the Fabric Community Forum:

How to Get Your Question Answered Quickly - Microsoft Fabric Community

 

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.  Proud to be a Super User!

View solution in original post

3 REPLIES 3
elitesmitpatel
Solution Supplier
Solution Supplier

Syndicated - Outbound

The trick seems cool and informative. can you just attach this file for easier reference.

Syndicated - Outbound

It appears that there is no upload button visible on this page.

Syndicated - Outbound

Hello @wujunmin , you will need to host the file on another cloud service (such as OneDrive, Google Drive, etc.) and anonymously share it using a sharing link as a reply to your original post.

 

Please take a moment to read over one of the cornerstone resources of the Fabric Community Forum:

How to Get Your Question Answered Quickly - Microsoft Fabric Community

 

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.  Proud to be a Super User!

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)