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
AlexML09
New Member

Emojis with UNICHAR doesnt work in a conditional with DAX

I have a table with a field "flag" (only 1 or 0), I need to show an emoji based on the value of this field. I tried the following adding a new column:

 

 

icon_flag =
VAR iconYes = UNICHAR(9989)
VAR iconNo = UNICHAR(10060)
RETURN
IF('Table'[flag] = 1, iconYes, iconNo)

 

 


But the column is showing the iconNo when te value of flag = 1.  If I change the value of the initial variables it works fine and I don't undestand why.


PS: The UNICHAR(9989) is for this emoji:  and the UNICHAR(10060) is for: 

2 REPLIES 2
Idrissshatila
Super User
Super User

Hello @AlexML09 ,

 

I tried your approach and its working

Idrissshatila_0-1698219708736.png

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




danextian
Super User
Super User

Hi @AlexML09 ,

 

I cannot replicate your issue. Please a sanitized copy of you pbix (confidential data removed) .

danextian_0-1698218639798.png

 





Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!


"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors