Embedding up and down arrows in visual and changing them based on condition

Hi tarun16feb

Here is the solution I discovered, 

use UNICHAR(9650) for up arrow and 

UNICHAR(9660) for a down arrow. 

 

Then make measure using dax:

YOY rev Arrow = var Red = UNICHAR(9660)

var Green = UNICHAR(9650)

return

if( [% growth Revenue]>0, Green, Red)

 

YOY rev Arrow, measure will give you up arrow when growth revenue is greater than 0 and down arrow when growth revenue is less than 0. But there is no color formatting yet. But the size of the arrows is same unlike some solutions mentioned above. 

 

Now for adding color formatting, green and red create another measure.

My condition was to have Green arrow up where growth is positive and red arrow down where growth is negative.

So, i made one measure using DAX:

 

YOY rev Arrow Condition =

if( [% growth Revenue]>0, 1,0)

 

Now pull the YOY rev Arrow measure into a KPI visual.

We will do color formatting in the KPI only.

 

Go to column format >> Data label >> add conditional formatting to the color of the data label

Select YOY rev Arrow Condition measure for applying rules

 

 

Add rules, Green where value is 1 and Red where value is 0.

You will get arrow and color formatting according to your filters. And It's dynamic. 

 

This is how the arrows will look:

 

 

I hope this helps.

 

Thanks,

Pragati Sidana

 

There are a few ways you can do this but the way I currently do this is based on the following: 

1) Growth % Measure: %YoY = Divide(([CYTD] - [PYTD]),([PYTD]))

2) Secondary Measure for Icons included within the %YOY: 
YOY%Icons  =
VAR Arrow =
SWITCH (
TRUE (),
[%YoY] < 0, UNICHAR ( 8659 ),
[%YoY] = 0, UNICHAR ( 8660 ),
[%YoY] > 0, UNICHAR ( 8657 )
)
RETURN
FORMAT ( [%YoY], "Percent" ) & " " & Arrow

3) Create conditional formatting on that column or card.

If >0 then green, if <0 then red. 

Final Result within card: 

Please like this message if this helped you figure out a viable solution to your issue. 🙂 

Hi tarun16feb,

Maybe you can use unichar instead. You can try it like this. You can find out more arrows here.

Measure =
IF ( MIN ( 'Table2'[Column1] ) < 600, UNICHAR ( 11014 ), UNICHAR ( 11015 ) )

Best Regards,

Dale

Hi.

Please follow the steps below.

- in the Values section, expand the options for the field you want the arrows.

- click Conditional formatting

- select Icons

- select the Style (the type of icon you want)

- set the rules

And you are done. 🙂

Let me know if this helps.

Thanks

Rohtashv

Hi  everyone

I have the same situation but comparing weeks so basically its on a card and the number is showing a week but the arrow would compare with previous week. if this week number is higher then up and vice versa. this is the measure we created but dont know how to include the up and down arrow.

This video explains this very well:)

https://www.youtube.com/watch?v=vv1RUpgodoE