Traffic light Arrow up and down

[evahohk]

How can I change traffic light to arrow up and down ? e.g. 

File location

[SamInogic]

We have checked the test report you have uploaded and these traffic light symbols are displayed due to the “Outcome Indicator” column.

You can change this icon to the arrow up or down based on the condition by changing the expression of this Outcome Indicator as follows:

Outcome Indicator = IF ( MIN ( Test[Outcome] ) < 2, UNICHAR ( 9650 ), UNICHAR ( 128315 ) )

Thanks!

Inogic

Innovative Logic  

Web: www.inogic.com/services/

Blog: http://www.inogic.com/blog

twitter: @inogic

[evahohk]

Thanks. But how can I change it to

Green up arrow if outcome is 1,

Red down arrow if outcome is 2

Other symbol with different colour if outcome is 3

Other symbol with different colour if outcome is 0

And how to adjust the size of the icon ? 
Some look bigger / smaller in the dashboard

File 

[SamInogic · Accepted solution]

In order to specify the Shape that needs to be displayed you need to change the expression of the Outcome Indicator as follows:

Outcome Indicator = SWITCH(MIN ( Test[Outcome] ),

1, UNICHAR ( 9650 ),

2,  UNICHAR ( 128315 ),

3, UNICHAR ( 9734 ),

0,UNICHAR ( 9733 ))

In this we have added Up arrow (UNICHAR ( 9650 )) for Outcome Value as 1, Down Arrow (UNICHAR ( 128315 )) for Outcome Value as 2,  other Star shape (UNICHAR ( 9734 )) for Value as 3, filled star shape (UNICHAR ( 9733 )) for Value as 0.

Now to change the colour being displayed for this shape need to change Font Color within the Conditional Formatting as shown in the below screenshot,

This will open the Font Colour dialog for Outcome Column; you can set the different colors for each value for Outcome Column. Please refer to the below screenshot for the same.

This will show the data in the table as you expected:

Thanks!

Inogic

Innovative Logic  

Web: www.inogic.com/services/

Blog: http://www.inogic.com/blog

twitter: @inogic

[evahohk]

Thank you so much ! It works !

[AbbasG]

Hi, @evahohk Refer to this post, it might help you to get the desired output.

https://community.powerbi.com/t5/Desktop/UNICHAR-Green-Up-arrow-and-Red-Down-arrow/m-p/379730#M17263...