Down and up arrow Indicators inside a score card and Changing the color based on conditions

[Anonymous]

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

[v-yuta-msft · Accepted 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]

Is it really possible to show conditional colour indicators inside a score card?

[Anonymous]

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