CODEWITHSUNDEEP
powerbi
Nelson Gomes Matias
Nelson Gomes Matias

Reputation: 1997

how to force sign on power bi visual card?

I'm looking for a solution that shows me on a card a percent number with sign. For example, if I have 10% groxth, I would like to see in the card: +10%

Thank you.

Upvotes: 1

Views: 49

Answers (1)

OscarLar
OscarLar

Reputation: 1335

There has to be a better solution than mine, but this works:

Measure = 
FORMAT(
    [Pct_measure];
    IF(
        [Pct_measure] >= 0;
         "+0.0%";
         "0.0%" // the negative sign will be carried automatically 
    )
)

NB this returns the value of [Pct_measure] as text.

Upvotes: 1

Related Questions