March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet 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
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
Blog: http://www.inogic.com/blog
twitter: @inogic
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
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
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
Blog: http://www.inogic.com/blog
twitter: @inogic
Thank you so much ! It works !
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
116 | |
88 | |
78 | |
65 | |
59 |
User | Count |
---|---|
140 | |
122 | |
105 | |
94 | |
90 |