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 Grow...
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
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