Forum Discussion
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.
CALCULATE([Movement by Filter CNPJ Menu x CNPJ PL Contas],FILTER(ALL(dCalendario),dCalendario[Data]<=MAX(dCalendario[Data])))
Att.
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.
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
4 Replies
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.
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
AndradeRobson please share dummy pbix and i will check it.