Forum Discussion

lawada's avatar
lawada
Icon for Helper III rankHelper III
4 years ago
Solved

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:

 

DAX Commands
tricks and tips
unichar
  • ValtteriN's avatar
    ValtteriN
    4 years ago

    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:

     



     


    End result:

    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/

2 Replies

  • ValtteriN's avatar
    ValtteriN
    Icon for Community Champion rankCommunity Champion
    4 years ago

    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:

     



     


    End result:

    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/