Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to make comparisons with float in DAX?

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

 

Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    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

7 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      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, ...)

       

  • Thejeswar's avatar
    Thejeswar
    Icon for Super User rankSuper User
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

       

      • v-easonf-msft's avatar
        v-easonf-msft
        Icon for Community Support rankCommunity Support
        4 years ago

        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