absolute value in kpi

[ioannagr]

Hello , i have a calculated measure in a KPI like this :

but I just wanna to keep the absolute value of it , so that the red colour and the downwards arrow only imply the downfall.

How do i do this?

Thank you in advance

[sunny_talwar · Accepted solution]

@ioannagr fabs() should do it? fabs(Yourexpression)

[ioannagr]

@sunny_talwar  hiii. Yes works like a charm but then green color appears because of the absolute value! Should i just put in the calculated measure but not in the conditional colours? 🤔

[sunny_talwar]

@ioannagr don't use it for the color expression

[ioannagr]

@sunny_talwar but then the color limit for the kpi doesn't work. And i still need to keep the colours and the respective arrows 😕

[sunny_talwar]

@ioannagr May be try to format the negative number as a positive number

Num(Yourexpression, '#.##0;#.##0')