Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

UNICHAR function not working as expected

I've just noticed, but there seems to be a bug with UNICHAR funciton, as it only shows the first character on a given selection.

UNICHAR error

I found a workaround. If you concatenate some string to the UNICHAR result, it works as intended.

Solution

Status: New
Comments
v-qiuyu-msft
Community Support

Hi @Mm3ndoza

 

Based on my test in Power BI desktop version 2.70.5494.761 64-bit (June 2019), the UNICHAR() function works fine. 

 

Measure = var _down=UNICHAR(11167)
var _up=UNICHAR(11165)
return SWITCH(TRUE(),SUM(Table1[Column2])<0,_down,_up)
 
q3.PNG

 

You can test with our sample report on your side as well. 

 

Best Regards,
Qiuyun Yu