Forum Discussion
Problem introducing UNICHAR
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.
If it still annoys you, try using the set of arrow icons from Conditional Formatting > Icons
3 Replies
- johnt75Super User
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/
- ray_aramburoSuper User
If it still annoys you, try using the set of arrow icons from Conditional Formatting > Icons
- AnonymousNot applicable
thanks ray_aramburo - did it with conditional formatting as you suggested in the end.