Forum Discussion
Solved
Add plus in the KPI
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 "+"
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?
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.
2 Replies
- I pretty sure I haven't understood your question...Delta arrow =VAR Red = UNICHAR(9660)VAR Green = UNICHAR(9650)returnif( [X Diff]>0, Green & "+", Red & "-")
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.
