Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

Mm3ndoza

UNICHAR function not working as expected

Submitted by on ‎07-15-2019 11:41 AM

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
See more ideas labeled with:
1 Comment (1 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎07-15-2019 11:41 PM

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

Idea Statuses