Table visual / Field Formatting / Display units: thousands - I get some 0s displayed as "-3E-34"

[AliceW]

Hello everyone,

This is happening for some of the lines where the amount is zero.

I have this beautiful table visual, and if I display the amounts with 'Display units' = None, it correctly displays 0.

However, if switch to 'Display units' = Thousands, I get "-3E-34'.

What's going on? The users are confused...

Thanks in advance,

Alice

[v-lid-msft]

Hi @AliceW ,

Sorry for that, but we can not reproduce this issue om my side, What is the type of your License column? Have you tried to reproduce this issue with latest version of Power BI Desktop?

Best regards,

[AliceW]

It's a decimal, and it's based on a measure. And people can see it in the Service version too.

Maybe it's because of this! The measure asks for zero to be divided by a number (say, 1.5). How do I get around that?

[v-lid-msft]

Hi @AliceW ,

Could you please share the formula of this measure if it does not contain any confidential information? Have you tried to use the DIVIDE(number1,number2,0) function?

Best regards,

[AliceW · Accepted solution]

While searching for the formula, I've discovered that the number I've imported from Salesforce (so, no formulas involved), is also displayed like that. So, the issue is here.

On a whim, I've changed this column's type from decimal to integer. It worked! No idea why, but it works for this AND the calculated column.

Thank you for your help in the thought process and your time on this.