Forum Discussion
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 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
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
4 Replies
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
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."
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
