Decimal position from Desktop report does not match when I upload that report file to website

[mhenning]

So I built a simple report using power BI desktop that includes a table to display values collected from a view in Azure. 

It sums the currency nicely rounds out to two decimal places. 

When I save the file then upload that to the powerBI website to share with my team, the rounding goes nuts. 

Any suggestions on how to deal with this?

[Greg_Deckler]

@mhenning - Where are you setting the display of the field, did you set this in the Modeling tab to be Currency ($) and specifically tell it 2 decimal places or in the visual?

I agree with @Anonymous, you may have to fix it on import so all those extra digits never exist in the model to begin with.

If you can't fix it outside of the query, you may want to submit a bug at support.powerbi.com, use the "Contact Us" link a little way down on the right-hand side.

EDIT: One other though, you could create another measure/column with something like:

=ROUNDDOWN([Yearly Sales Goal],2)

And use that in your table and see if that fixes it.

[lprbi]

Same problem here. Service not respecting anymore the decimal format you do on Desktop. (last version problem)

Need real solution.

[lprbi]

Ticket Open

[Anonymous]

Hi mhenning,

   you can solve it in the Query Editor :

1) Select the "Yearly Sales Goal" column

2) Transform -> Rounding -> Round...

3) Select the number of decimals

I'm not an expert user, so let me know if it works.

p.s. The value of the "Yearly Sales Goal" column is obtained from a calculation? Because maybe when you upload the file in PowerBI, it keeps all the decimals.