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

     

     

amitchandak's avatar
amitchandak
Super User
6 years ago

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's avatar
    Anonymous
    Not applicable
    6 years ago

    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.