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.

View solution in original post

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?

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.

View solution in original post

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
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 47 members 956 guests
Please welcome our newest community members: