Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I need an urgent help. I am very new to Power BI. I am displaying Down and Up arrow indicators inside a Score Card. But as per my project requirement they want coloured arrows.
I am facing issue with unichar color code.
This is the requirement as below:
Arrows to be used to show the movement as per the status quo. Logic for the arrow and colour is mentioned below
Arrows are derived based on the values compared between current month column (Nov-18) and previous month column (Oct-18)
Nov-18 = Oct-18 display balanced symbol in black
Nov-18 < Oct-18 display Down arrow and the difference is 1 or 2 then in Yellow color
Nov-18 < Oct-18 display Down arrow and the difference is more than 2 then in Red color
Nov-18 > Oct-18 display Up arrow and the difference is 1 or 2 then in Yellow color
Nov-18 > Oct-18 display Up arrow and the difference is more than 2 then in Green color
Business Unit | Business Unit Group | 18-Nov | 18-Oct | Symbols | Arrows | MoM Diff |
Group | Group | 20 | 20 | ↔ | ↔ | 0 |
C&SB | C&SB Overall | 26 | 27 | ▼ | ▼ | -1 |
C&SB | Sales and Activation | 40 | 39 | ▲ | ▲ | 1 |
C&SB | Modify | 52 | 51 | ▲ | ▲ | 1 |
C&SB | Move | 25 | 29 | ▼ | ▼ | -4 |
C&SB | First Bill | 11 | 10 | ▲ | ▲ | 1 |
C&SB | Assurance | 4 | 9 | ▼ | ▼ | -5 |
Enterprise Overall | Enterprise Overall | 7 | 7 | ↔ | ↔ | 0 |
TE-A Overall | TE-A Overall | 7 | 7 | ↔ | ↔ | 0 |
TE-A Overall | Assurance | -20 | -4 | ▼ | ▼ | -16 |
TE-A Overall | O2A/MACs | 34 | 19 | ▲ | ▲ | 15 |
Thanks In Advance
Tanu
Solved! Go to Solution.
@Anonymous,
Though I haven't found the unichar for yellow and green symbol, as a workaround, you can also refer to pattern below:
Symbol = VAR flag = 'Table'[18-Nov] - 'Table'[18-Oct] RETURN SWITCH ( TRUE (), flag = 0, "↔", flag < 0 && ( ABS ( flag ) = 1 || ABS ( flag ) = 2 ), UNICHAR ( 128317 ), flag < 0 && ABS ( flag ) > 2, UNICHAR ( 128315 ), flag > 0 && ( ABS ( flag ) = 1 || ABS ( flag ) = 2 ), UNICHAR ( 128316 ), flag > 0 && ABS ( flag ) > 2, UNICHAR ( 128314 ) )
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous,
Though I haven't found the unichar for yellow and green symbol, as a workaround, you can also refer to pattern below:
Symbol = VAR flag = 'Table'[18-Nov] - 'Table'[18-Oct] RETURN SWITCH ( TRUE (), flag = 0, "↔", flag < 0 && ( ABS ( flag ) = 1 || ABS ( flag ) = 2 ), UNICHAR ( 128317 ), flag < 0 && ABS ( flag ) > 2, UNICHAR ( 128315 ), flag > 0 && ( ABS ( flag ) = 1 || ABS ( flag ) = 2 ), UNICHAR ( 128316 ), flag > 0 && ABS ( flag ) > 2, UNICHAR ( 128314 ) )
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Is it really possible to show conditional colour indicators inside a score card?
Did you manage to find a solution for this ? I am also trying to figure out if you can apply conditional formating to arrows in a score card
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |