topic Re: unichar with colors in DAX Commands and Tips

unichar with colors

lawada — Fri, 28 Jan 2022 19:46:23 GMT

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:

Re: unichar with colors

ValtteriN — Fri, 28 Jan 2022 20:00:42 GMT

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/

Re: unichar with colors

lawada — Fri, 28 Jan 2022 20:33:02 GMT

thanks solution has worked for me