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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount 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