Forum Discussion

Pbiuserr's avatar
Pbiuserr
Post Prodigy
4 years ago
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 format...
Need Help
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    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's avatar
KerKol
Power Participant
4 years ago
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 & "-")