Colour Unichar arrow measure

[amaleranda]

Hi PowerBI Gurus, 

I have created below measure to show an arrow based on value go up and down.

Arrow works fine. But I need to make it green when it pointing up and make it red when it is pointing down.

my measures are as below

Measure 1(used in final arrow measure)

-------------------------------------------------------------------

Minutes := 

CALCULATE(
           SUM(

                    Tabel1[CallMinute]

                 )

)

----------------------------------------------------------------------

Measure2(used in final arrow measure)

-------------------------------------------------------

Forcast := 

CALCULATE(

         SUM( Table1[Target]

            )

)

-------------------------------------------------------------------------------------------

Finial Arrow Measure

===================================================

ArrowUpDown := 

VAR Arrow = SWITCH(TRUE( ),

                                    [Forcast] < 0, UNICHAR(129095),

                                    [Minutes] > 0, UNICHAR(129093),

                                    BLANK( )

                                 )

RETURN

IF(

    ISBLANK(Arrow), " ", Arrow

)

====================================================

i used this measure in a tabel column. 

I haev tried formating this measure using other columns in the tabel like Tabel1[CallMinute] and Table1[Target].

Your help is much appriciated.

Regards

Amal Eranda

[Anonymous · Accepted solution]

Hi,

I have created the below pbix.

Check if this is what you need.

https://1drv.ms/u/s!AikPceQOhqFEhAQ4rRsY7aWI1MVh?e=bgzjJF

Thanks.

[Anonymous]

Hi,

Can you help me with some sample data.

Thanks.

[amaleranda]

ID    Target     Minute

1      -500       0

this tabel has only one recoad and at a given time either target or minute column has 0. Both columns cannot have values at the same time.  I can add some other columns if required. 

Thanks a lot for looking at this. If you need more infomation please let me know.

[Anonymous · Accepted solution]

Hi,

I have created the below pbix.

Check if this is what you need.

https://1drv.ms/u/s!AikPceQOhqFEhAQ4rRsY7aWI1MVh?e=bgzjJF

Thanks.

[amaleranda]

I cannot open it from my work computer. would you be able to flick the file to my email as on this account.

Thanks a lot

[Anonymous]

Can you help me with the email id? I am not able to find it.

Thanks.

[amaleranda]

Hi Champion, 

It is amal.eranda@gmail.com

I really appriciate your help.

Regards

[Anonymous · Accepted solution]

File Sent.

Thanks.

[amaleranda]

You are a Champion.