How to make comparisons with float in DAX?

[Anonymous]

Hi everyone, hope you are well 🙂

I'm trying to make a measurement that, depending on the daily variation, displays an icon for positive or negative.

But if the number the variation has decimal places (-0.05) does not work.

Even with the negative number in percentage this occurs.

Does anyone have any idea what to do in these cases?

thx

[Thejeswar]

Hi @Anonymous ,

Usually defining Indicators should be done on the Number and not on the percentage.

i.e. Control the display of Indicator using the Number by keeping the value as a number datatype and just  for display make the number as percentage

May be this could solve this issue!!

[Anonymous]

[v-easonf-msft · Accepted solution]

Hi, @Anonymous 

I checked your measure 'indicador base64' and found that you have offset the calendar table by one day.

DateADD(
    oCalendario[Date],
    -1,
    Day
)

You may need to remove this filter. The code in the SWITCH section  is sufficient for your needs.

Best Regards,
Community Support Team _ Eason

[Anonymous]

Thx ❤️

[Anonymous]

If you notice in the first image my attempt is with decimal number

[amitchandak]

@Anonymous , Try to use unichar like this, see if that can help

/////Arrow
Arrow =
var _change =[Net Sales YTD]-[Net Sales LYTD]
return
SWITCH (
TRUE(),
_change > 0, UNICHAR(9650),
_change = 0, UNICHAR(9654),
_change < 0, UNICHAR(9660)
)

/////Arrow Color , use in conditional formatting using field value option

Arrow color =
var _change =[Net Sales YTD]-[Net Sales LYTD]
return
SWITCH (
TRUE(),
_change > 0, "green",
_change = 0, "blue",
_change < 0, "red"
)

UNICHAR - Tool for Custom Icon Formatting: https://www.youtube.com/watch?v=veCtfP8IhbI&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=50

[Anonymous]

Thanks for replying, my icon works fine, my problem is with the values ​​in the comparison. Note that the value is negative but the icon points to positive! I believe it is a problem with decimal numbers since this only happens when the value has places to the right (-0.05, -0.065, ...)