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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

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.

Megz_0-1691045089514.png

 

 

Then I try

 

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

 

and I get the result I expect

Megz_1-1691045176651.png

 

 

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

Megz_2-1691045279454.png

 

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.

 

1 ACCEPTED SOLUTION
ray_aramburo
Super User
Super User

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





Did I answer your question? Give your kudos and mark my post as a solution!

Proud to be a Super User!





View solution in original post

3 REPLIES 3
ray_aramburo
Super User
Super User

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





Did I answer your question? Give your kudos and mark my post as a solution!

Proud to be a Super User!





Anonymous
Not applicable

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

johnt75
Super User
Super 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/ 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.