Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
wujunmin
Advocate III
Advocate III

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

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
Super User
Super User

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

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

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!

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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