cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lawada
Helper III
Helper III

unichar with colors

i have created arrows  using unichar function and added within my card visual , is there any workaround to get the arrows colored to green when it goes up , red when it goes down and yellow otherwise 

my current KPIs looks like this:

lawada_0-1643399304697.png

 

1 ACCEPTED SOLUTION
ValtteriN
Super User
Super User

Hi,

You can do this with format measure:

E.g.

DAX:

arrow = IF('Value for arrow'[Value for arrow Value]>0,UNICHAR(9650),UNICHAR(9660))
Format arrow = IF('Value for arrow'[Value for arrow Value]>0,"Green","Red")
Place custom format here:
ValtteriN_1-1643399992574.png

 



ValtteriN_0-1643399971445.png

 


End result:

ValtteriN_2-1643400016099.png

ValtteriN_3-1643400029389.png

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

2 REPLIES 2
lawada
Helper III
Helper III

thanks solution has worked for me

ValtteriN
Super User
Super User

Hi,

You can do this with format measure:

E.g.

DAX:

arrow = IF('Value for arrow'[Value for arrow Value]>0,UNICHAR(9650),UNICHAR(9660))
Format arrow = IF('Value for arrow'[Value for arrow Value]>0,"Green","Red")
Place custom format here:
ValtteriN_1-1643399992574.png

 



ValtteriN_0-1643399971445.png

 


End result:

ValtteriN_2-1643400016099.png

ValtteriN_3-1643400029389.png

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors