Forum Discussion
Show indicator (arrow up), (arrow down) COLOR based on MEASURES
Hello Experts,
I would like to show indicators in my TILES.
- Indicators should be arrrows - like UNICHAR ( 9650 ) and UNICHAR ( 9660 ) / UNICHAR ( 128317 )
- Indicators should be colored GREEN and RED
- Indicators should be colored based on MEASURES - e.g. comparion vs YTD and YTD LY - measures - not columns (if the YTD > YTD LY = arrow up and vice versa)
I was trying to use UNICHAR ( 128317 ) as red colored arrow - works in PBI Desktop but not in Power BI Service.
PBI Desktop - works (image 1) , PBI Service - does not work (image 2)
I am using a measure like this to achieve this result.
Total PLV %change arrow =
SWITCH (
TRUE ();
ISBLANK ( [Total PLV YOY YTD] ); "";
ISBLANK ( [Total PLV YTD LY] ); "";
[Total PLV YOY YTD] <= 0; "";
[Total PLV YOY YTD] >= [Total PLV YTD LY]; UNICHAR ( 9650 );
[Total PLV YOY YTD] <= [Total PLV YTD LY]; UNICHAR ( 9660 ) ;
BLANK ()
)
What would you recomend to me? I would like to just avoid installing custom visuals.
Thanks,
Martin-Prague
3 Replies
- v-chuncz-msft
Community Support
You may try using conditional formatting instead.
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting
- Martin-Prague
Helper II
v-chuncz-msft Conditional formatting does not work for MEASURES in my case.
And due to company constrains I cannot use higher version than 2.54 of PBI currently, maybe it is comming.
Anyways I would like to use arrows pointing up/down.
- Martin-Prague
Helper II
Any other suggestion?