Forum Discussion
Power Bi Rounding Decimal Numbers up, even when not formatted to do so
I have a Total $ Sales Field that is brought in as a Decimal Number, Format set to Currency and two Decimal Places that is consistently rounding when display within a table. Need some help figuring out why.
Visual with issue:
Field Formatting:
Within Transform Data (Direct Query so I cannot jump to just a table). There are Fields between identifier and Field in question, so two pictures:
Visual Customization:
Hi Ereon ,
Thanks for the update and apologies for the delay.This issue seems to be related to the new Snowflake connector introduced in recent Power BI Desktop versions. When using DirectQuery, decimal values may appear rounded during aggregation even though the source data and preview show correct values.
To work around this, go to File > Options and settings > Options > Preview features, and uncheck “Use new Snowflake connector implementation”. Restart Power BI and reload the dataset.
Hope this helps. Please reach out for further assistance.
If this post helps, then please consider to Accept as the solution to help the other members find it more quickly.
Thank you.
19 Replies
Hi Ereon :
On your 4th picture under 'Specific Colunm', would you want to adjust that 'Value decimal places' from 'Auto' to '2' and see if this will change your decimals on the report? Usually this overrides the decimals in your report, but i might be wrong.
Please let me know if this works or if there's other configuration that affected your decimals.
Thanks
Mason
The issue is not the number of decimal places, it is that the Field consistently rounds to the dollar and drops all decimal numbers.
I cannot supply the file as it is internal company data. Was able to mask all information for the purpose of gaining some help, but cannot share.
Hi Ereon
Please try this format $ #,##0.00;-$ #,##0.00 or this $ #,##0.00;($ #,##0.00)
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thank you.
Still have the rounding issue. This also does not really solve the problem, as the Field dropped into any table produces the same rounding error.
Hi Ereon ,
Thanks for posting in Microsoft Fabric Community.Thanks again for sharing the screenshots and confirming the formatting settings. I was able to reproduce a similar scenario in my environment and found that when the Data Type is set to Whole number for the column in the Model view like below, it appears as .00.
But when i changed it to Decimal number
it's correctly shown like below
Please click refresh after changing the data type.
If unable to do this in Direct Query:
--Check the data type of the Total $ Sales column in your source system.
--If it's defined without decimal precision, consider updating it to a type that supports decimals - such as DECIMAL(12,2) or NUMERIC(12,2).
Once the column allows decimal precision at the source level, Power BI will reflect the correct values in your visuals.
Hope this helps. Please reach out for further assistance.
If this post helps, then please consider to give a kudos and Accept as the solution to help the other members find it more quickly.
Thank you.Please find the attached .pbix file.
The data comes in as a Decimal Number, which makes this so confusing for me. This is a DirectQuery due to the size of the data model.
And the tables show the decimal places correctly when I go to Transform Data.
Hi Ereon ,
Thanks for the update.
Since the column is already in decimal number format and the field shows correct values in both Snowflake and the Power Query preview, the issue could be related to how the values are being handled in the visual.
As a next step, try setting the column to "Don’t Summarize" in the table visual. This will ensure that the values are displayed directly without any implicit aggregation that might affect how they're shown.
You can also create a simple measure like MAX('Table'[Total $ Sales]) and add it to the same visual to see if it behaves any differently from the column.
Just as a general note, Power Query may sometimes infer data types based on the first few rows. If those happen to contain only whole numbers, it might initially assign the column a whole number type. You can check or change this by going to Transform Data, right-clicking the column header, selecting Change Type, and choosing Decimal Number to ensure the type is interpreted correctly.
You may also want to ensure you're on the latest version of Power BI Desktop, as earlier versions can occasionally have display or formatting inconsistencies that are resolved in newer builds.
Let us know if this helps.
If this post helps, then please consider to give a kudos and Accept as the solution to help the other members find it more quickly.
Thank you.
Sorry, no solution to your issue but I am having the same problem. Data comes from SnowFlake (direct query) and the column comes through as a decimal number. The values are correct when they're not summed, but as soon as it is summed the rounding is applied.
Could this be a bug in the latest version of PBI deskop (Version: 2.144.679.0 64-bit (June 2025))
I have never experienced anything like this before.Edit: All my problems are solved when I switch from Direct Query to Import. Unfortunately, using import is not always suitable.
Good to know I am not alone in this issue. I cannot change over to Import because the data coming in is way to large. 3 years of sales, for over 2,500 stores, by day, by Item.
Hi Ereon ,
Just checking in again to see if your issue is resolved and if any responses helped. If you need any further assistance, please reach out.Thank you.
