Forum Discussion
Zero Values Displaying Weird Value On Visuals
Hello power people!
I'm facing a wierd bug here I believe.
I have a measure that calculates balance of the transactions
Here is the measure expression:
Balance = CALCULATE(SUM(TransTable[AMOUNTMST]),FILTER(ALL('Date'),'Date'[Date]<=MAX('DATE'[Date])))
This measure is to sum all transactions amount with ignoring the "From date" filter of the slicer.
The values i'm getting are correct, except the 0 values.
I have 3 accounts with "Zero" balances in the results which are correct, they are zero in total.
But my issue is the Bar visuals are displaying weird value instead of 0 (Zero).
Here is a screenshot of the visual with the wierd value:
As you can see, there are 2 weird values and a normal 0 value showing up.
And when I click on "Show data" on the visual here is the result:
What is the issue?
Thanks in advance!
Hi,
They are very small values. See if you can suppress them with the ROUND() function.
5 Replies
I_NeedMorePower , Check if the format is scientific, then change it to decimal under column or measure tool
Thank you for your time to help!
But the measure is already in decimal format.
The Round() function did the trick as suggested by Ashish_Mathur
Thank you 🙂
Hi,
They are very small values. See if you can suppress them with the ROUND() function.
Thank you Ashish_Mathur ! it did the trick!
But I need to make sure if the cause was very small values
Anyway thanks again! 🙂
Hi I_NeedMorePower ,
Please let us know if the replies above are helpful.
If they are, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If not, please give us more details.
Best Regards,
Icey
