cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Tanusha Frequent Visitor
Frequent Visitor

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

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 UnitBusiness Unit Group18-Nov18-OctSymbolsArrowsMoM Diff
GroupGroup20200
C&SBC&SB Overall2627-1
C&SBSales and Activation40391
C&SBModify52511
C&SBMove2529-4
C&SBFirst Bill11101
C&SBAssurance49-5
Enterprise OverallEnterprise Overall770
TE-A OverallTE-A Overall770
TE-A OverallAssurance-20-4-16
TE-A OverallO2A/MACs341915

 


Thanks In Advance

Tanu

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

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

@Tanusha,

 

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

Capture.PNG 

 

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.

2 REPLIES 2
Tanusha Frequent Visitor
Frequent Visitor

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

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

Highlighted
Community Support Team
Community Support Team

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

@Tanusha,

 

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

Capture.PNG 

 

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.