Add plus in the KPI

[Pbiuserr]

Hello,

I've created custom KPI from card using this formula

Delta arrow =

VAR Red = UNICHAR(9660)

VAR Green = UNICHAR(9650)

return

if( [X Diff]>0, Green, (Red))

plus conditional formatting flag

Delta Condition MTTR =

if( [X Diff]>0, 1,0 ) - 0 is red 1 is green

However I'd like to add "+" or "-" to the Delta Arrow so if arrow is down then value which show change (Current vs Last Month) is with "-", if above 0 then is with "+" 

Any suggestions how to add it?

[v-zhangti · Accepted solution]

Hi, @Pbiuserr 

Measure:

Delta arrow = 
VAR Red = UNICHAR(9660)
VAR Green = UNICHAR(9650)
return
if(SELECTEDVALUE('Table'[X Diff])>0, "+"&Green, "-"&Red)

Delta Condition MTTR = 
IF(SELECTEDVALUE('Table'[X Diff])>0,"Green","Red")

In the Conditional Format pane, set the format of the color to Delta Condition MTTR.

Is this the output you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[KerKol]

I pretty sure I haven't understood your question...

Delta arrow =

VAR Red = UNICHAR(9660)

VAR Green = UNICHAR(9650)

return

if( [X Diff]>0, Green & "+", Red & "-")