- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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?
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: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: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>"
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

The trick seems cool and informative. can you just attach this file for easier reference.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

It appears that there is no upload button visible on this page.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
07-26-2024 12:47 AM | |||
10-18-2024 02:54 AM | |||
05-03-2024 03:51 AM | |||
12-19-2023 05:53 AM | |||
08-08-2024 09:09 AM |
User | Count |
---|---|
89 | |
82 | |
54 | |
40 | |
35 |