Show arrow indicator based on specific condition in Matrix Table

[Anonymous]

Hi All,

I want to create a new column in my Matrix table called "Indicator" to show arrow indicator (arrow up - green, arrow down - red).

Using the example below, I want to show green if Growth% is greater than Total then Arrow Up, else Arrow Down.

Malaysia : Arrow Down (146% < 168%)

Malaysia - A : Arrow Up (178% > 168%)

I can set the icon for C, D, A, B but not able to set icons for Indonesia and Malaysia row.

Update

Hi, I can set the icon for Indonesia and Malaysia but not able to set the color for the icons.

Regards,

BK

[Mariusz · Accepted solution]

Hi @Anonymous 

You can use a measure that returns UNICHAR, but you lose the colours, another option is to use emojis.

arrows = 
IF( 
    [Sales CY vs LY %] > CALCULATE(  [Sales CY vs LY %], ALL( 'Product' ) ), 
    UNICHAR( 129153 ), 
    UNICHAR( 129155 ) 
)

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[MFelix]

Hi @Anonymous ,

I'm assuming that the Growth % is a measure if yes you can do a measure similar to this:

ARROWINDICATOR =
SWITCH (
    TRUE ();
    [Growht%] > 1,46
        && [Growht%] < 1,68; UNICODE ( "U+25BC" );
    [Growht%] > 1,68
        && [Growht%] < 1,78; UNICODE ( "U+25B2" )
)

Be aware that this only give black arrows then you can use condittional formatting to make the colouring.

Check the documentation on how to achieve this:

https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting

you can also use icons

https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#add-icons

However be aware that 

[amitchandak]

In the matrix, you have a show icon. Refer for details:https://powerbi.tips/2019/07/icons-upon-icons/

"Click on the Advanced Controls to set the properties of the icons based on the data properties. This type of dialog box should look familiar as it is similar to the previous boxes for conditional formatting. Opening this window shows Icons for each Rule in the list. To adjust an icon Click on the Drop Down Arrow next to the icon you wish to change. There are multiple icons to choose from."

[Anonymous]

Hi, I can set icons for C, D, A, B but not able to set for Malaysia and Indonesia row. This is currently what I have now.