Forum Discussion
Decimal position from Desktop report does not match when I upload that report file to website
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. Wh...
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.
