Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
@ioannagr fabs() should do it? fabs(Yourexpression)
@ioannagr fabs() should do it? fabs(Yourexpression)
@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? 🤔
@ioannagr don't use it for the color expression
@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 😕
@ioannagr May be try to format the negative number as a positive number
Num(Yourexpression, '#.##0;#.##0')