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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

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