Forum Discussion

AndradeRobson's avatar
AndradeRobson
Helper II
2 years ago
Solved

Problems with value 0.00

Goodnight! I need help with the value 0.00 in the DAX measure, as it is leaving the graph value with an error of 2.05E11 instead of 0.00. How could I solve it? Below is the function used. CALCULA...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi AndradeRobson 
    Try to use a dynamic string format, it should help.

    All guides show currencies, but it works perfectly on numbers too.

    https://www.youtube.com/watch?v=s4jeX9EKON4

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

  • AndradeRobson's avatar
    AndradeRobson
    2 years ago

    Rita, good morning!

    Thank you very much for the tips.
    I believe that POwer Bi had a bug, because in the view, I deleted the DAX function, updated all the tables and then added the function again and it worked.

    Att.

    Robson

Ritaf1983's avatar
Ritaf1983
Super User
2 years ago

Hi AndradeRobson 
Try to use a dynamic string format, it should help.

All guides show currencies, but it works perfectly on numbers too.

https://www.youtube.com/watch?v=s4jeX9EKON4

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

  • AndradeRobson's avatar
    AndradeRobson
    Helper II
    2 years ago

    Thanks for the tip.

    But the table number 0.00 still appears in this strange format on the graph.
    Has anyone had this problem?

    Att.

    Robson

    • Ritaf1983's avatar
      Ritaf1983
      Super User
      2 years ago

      AndradeRobson  please share dummy pbix and i will check it.

      • AndradeRobson's avatar
        AndradeRobson
        Helper II
        2 years ago

        Rita, good morning!

        Thank you very much for the tips.
        I believe that POwer Bi had a bug, because in the view, I deleted the DAX function, updated all the tables and then added the function again and it worked.

        Att.

        Robson