Problem introducing UNICHAR

[Anonymous]

I want to put up and down arrows on a set of data.

I start simple

Arrow = 
SWITCH(TRUE,
        [This Week] > 0, "Up",
        [This Week] < 0, "Down",
        "Side"
)

and I get the result I expect.

Then I try

Arrow = 
SWITCH(TRUE,
        [This FY] > 0, UNICHAR(11165),
        [This FY] < 0, "Down",
        "Side"
)

and I get the result I expect

Then I add the other unichars

Arrow = 
SWITCH(TRUE,
        [This FY] > 0, UNICHAR(11165),
        [This FY] < 0, UNICHAR(11167),
        UNICHAR(11166)
)

and I don't get what I expect to see

I also tried the below but got the same result

Arrow = 
VAR Up = UNICHAR(11165)
VAR Down = UNICHAR(11167)
VAR Side = UNICHAR(11166)
RETURN
SWITCH(TRUE(),
        [This FY] > 0, Up,
        [This FY] < 0, Down,
        Side
)

What am I doing wrong?  I've read through a fair few threads on Unichar issues and can't see where I'm going wrong.

[ray_aramburo · Accepted solution]

If it still annoys you, try using the set of arrow icons from Conditional Formatting > Icons

[Anonymous]

thanks @ray_aramburo - did it with conditional formatting as you suggested in the end.

[johnt75]

This seems to be a bug in Power BI. You can see in the attached pbix file that every value is returning the up arrow whereas it works correctly on dax.do - https://dax.do/lEEKvPALKstpSY/