Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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

Inogic Professional Services: Power Platform/Dynamics 365 CRM
An expert technical extension for your techno-functional business needs
Drop an email at crm@inogic.com
Service: https://www.inogic.com/services/
Tips and Tricks: https://www.inogic.com/blog/

View solution in original post

5 REPLIES 5
SamInogic
Super User
Super User

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

Inogic Professional Services: Power Platform/Dynamics 365 CRM
An expert technical extension for your techno-functional business needs
Drop an email at crm@inogic.com
Service: https://www.inogic.com/services/
Tips and Tricks: https://www.inogic.com/blog/

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

Inogic Professional Services: Power Platform/Dynamics 365 CRM
An expert technical extension for your techno-functional business needs
Drop an email at crm@inogic.com
Service: https://www.inogic.com/services/
Tips and Tricks: https://www.inogic.com/blog/

Thank you so much ! It works !

AbbasG
Memorable Member
Memorable Member

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.