Hi I am facing issue at one report for KPI arrow colors(Suggest calculated column or Measure)

[Anonymous]

Hi Team , 

I need your help for one report which is having ,

Arrow(upward/Downward)   Target   YTD   PYTD

The logic for arrow for ex. goal is in (goal 1,goal2 and goal3) and (YTD>PYTD ) is upward arrow with green color

and Red downward when goal is in (goal 1,goal2 and goal3) and (YTD<PYTD )

and for  goal is in (goal 4,goal5 and goal6) and (YTD>PYTD ) is upward arrow with REd color and

Green down when goal is in (goal 4,goal5 and goal6) and (YTD<PYTD )

I have column Goal, YTD,PYTD, Arrow ,YTDvsPYTD all working fine but not able to define color code can you please help with creating Calculated column or Measure for having colored arrows.

I tried but not getting answer.Conditional color formating also not working as desired.

Regards,

Arundhati

[amitchandak · Accepted solution]

@Anonymous , You can have measures like these

Arrow =
var _change =[Net Sales YTD]-[Net Sales LYTD]
return
SWITCH (
TRUE(),
_change > 0, UNICHAR(9650),
_change = 0, UNICHAR(9654),
_change < 0, UNICHAR(9660)
)

/////Arrow Color
Arrow color =
var _change =[Net Sales YTD]-[Net Sales LYTD]
return
SWITCH (
TRUE(),
_change > 0, "green",
_change = 0, "blue",
_change < 0, "red"
)

you can use color in conditional formatting with the field value option

UNICHAR Tool for Custom Icon Formatting: https://www.youtube.com/watch?v=veCtfP8IhbI&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=50

[Anonymous]

Hi Amit,

Thanks for solution similar logic worked for me.