Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi
I'm having a really weird issue when i try to return a unichar character from an if-function or a switch.
I recreated the problem in a new powerbi report.
I want to return ✅ when the value equals 1, and ❌ when it doesn't.
So i tried this first, which seems to be working fine:
When i substitute blank by the unichar code for ❌, it doesn't work anymore:
Neither does switch:
Did anybody else run in to this problem before?
I'm having the exact same issue, has anyone come up with a solution?
I'm on May 24 version
No, I think i just ended up using different characters.
128308 for a red button 🔴
128994 for a green one 🟢
@EmilePl , I tried on latest version of power bi and it works for me
example code
Column 2 = if( [Category Id] < 3 , UNICHAR(9989), UNICHAR(10060))
Hi @amitchandak
Thanks for your reply!
I think i am on the latest version as well?
Last version i can find here is 2.121.903.0, somehow i am on 2.121.942.0
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!