cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
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.

3 REPLIES 3
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?

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.

Anonymous
Not applicable

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

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 

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 184 members 2,750 guests
Please welcome our newest community members: