Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Show arrow indicator based on specific condition in Matrix Table

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 Grow...
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    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

     

     

Mariusz's avatar
Mariusz
Community Champion
6 years ago

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