cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
evahohk
Helper I
Helper I

Traffic light Arrow up and down

evahohk_0-1670382935421.png

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

evahohk_1-1670383012382.png

File location

 

1 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,

Traffic Light.jpg

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.

1Traffic Light.jpg

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

2Traffic Light.jpg

 

Thanks!

Inogic

Innovative Logic  

Web: www.inogic.com/services/

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

twitter: @inogic

View solution in original post

5 REPLIES 5
SamInogic
Resolver III
Resolver III

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 ) )

Traffic Light.jpg

 

Thanks!

Inogic

Innovative Logic  

Web: www.inogic.com/services/

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

twitter: @inogic

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

evahohk_0-1670392595159.png

 

File 

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,

Traffic Light.jpg

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.

1Traffic Light.jpg

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

2Traffic Light.jpg

 

Thanks!

Inogic

Innovative Logic  

Web: www.inogic.com/services/

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

twitter: @inogic

Thank you so much ! It works !

AbbasG
Solution Sage
Solution Sage

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.