Show indicator (arrow up), (arrow down) COLOR based on MEASURES

[Martin-Prague]

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

[v-chuncz-msft]

@Martin-Prague,

You may try using conditional formatting instead.

https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting

[Martin-Prague]

@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]

Any other suggestion?