cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper II
Helper II

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)

PBI desktop.pngPBI Service.png

 

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 3
Community Support
Community Support

@Martin-Prague,

 

You may try using conditional formatting instead.

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

conditinal formatting n_a.PNG

Anyways I would like to use arrows pointing up/down.

Any other suggestion?

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors