cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
amaleranda Regular Visitor
Regular Visitor

Colour Unichar arrow measure

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

 

 

 

 

 

 

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
vaibhavdesai Established Member
Established Member

Re: Colour Unichar arrow measure

Hi,

I have created the below pbix.

Check if this is what you need.

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

Thanks.

View solution in original post

vaibhavdesai Established Member
Established Member

Re: Colour Unichar arrow measure

File Sent.

Thanks.

View solution in original post

8 REPLIES 8
vaibhavdesai Established Member
Established Member

Re: Colour Unichar arrow measure

Hi,

Can you help me with some sample data.

Thanks.

amaleranda Regular Visitor
Regular Visitor

Re: Colour Unichar arrow measure

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.

 

 

vaibhavdesai Established Member
Established Member

Re: Colour Unichar arrow measure

Hi,

I have created the below pbix.

Check if this is what you need.

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

Thanks.

View solution in original post

amaleranda Regular Visitor
Regular Visitor

Re: Colour Unichar arrow measure

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

vaibhavdesai Established Member
Established Member

Re: Colour Unichar arrow measure

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

Thanks.

amaleranda Regular Visitor
Regular Visitor

Re: Colour Unichar arrow measure

Hi Champion, 

 

It is amal.eranda@gmail.com

 

I really appriciate your help.

 

Regards

 

vaibhavdesai Established Member
Established Member

Re: Colour Unichar arrow measure

File Sent.

Thanks.

View solution in original post

amaleranda Regular Visitor
Regular Visitor

Re: Colour Unichar arrow measure

You are a Champion.

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors