Add plus in the KPI

Question

Hello,I've created custom KPI from card using this formula&nbsp;Delta arrow = VAR Red = UNICHAR(9660)VAR Green = UNICHAR(9650)returnif( [X Diff]&gt;0, Green, (Red))&nbsp;plus conditional formatting flag&nbsp;Delta Condition MTTR = if( [X&nbsp;Diff]&gt;0, 1,0 ) - 0 is red 1 is greenHowever 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 "+"&nbsp;Any suggestions how to add it?

v-zhangti · Accepted Answer

Hi,&nbsp;Pbiuserr&nbsp;
&nbsp;
Measure:
Delta arrow = 
VAR Red = UNICHAR(9660)
VAR Green = UNICHAR(9650)
return
if(SELECTEDVALUE('Table'[X Diff])&gt;0, "+"&amp;Green, "-"&amp;Red)Delta Condition MTTR = 
IF(SELECTEDVALUE('Table'[X Diff])&gt;0,"Green","Red")
In the Conditional Format pane, set the format of the color to Delta Condition MTTR.

Is this the output you expect?
&nbsp;
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.

Forum Discussion

Related content

Power Query Add rows of zero amount

Add Filter

Can't add workspace user

Add Measures to Slicer

No table to add Lakehouse