cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Post Prodigy

## 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 "+"

Any suggestions how to add it?
1 ACCEPTED SOLUTION
Community Support

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 2
Community Support

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.

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

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

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors