The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
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!
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!
User | Count |
---|---|
86 | |
84 | |
36 | |
34 | |
34 |
User | Count |
---|---|
93 | |
79 | |
66 | |
55 | |
52 |