Power Bi Rounding Decimal Numbers up, even when not formatted to do so

[Ereon]

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:

[d_vanstrien]

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.

[Ereon]

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.

[v-veshwara-msft]

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.

[Ereon]

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.

[v-veshwara-msft]

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.

[Ereon]

Already have the value set to not Sum and same issue.  Someone else posted they are encountering this as well with Direct Query from Snowflake.  First time I have had it though, as I have several dashboards pulling from Snowflake, but none have used this dataset till now.

[WishAskedSooner]

@Ereon,

I am replying as an olive leaf for all the help I have gotten on this forum even though AI is a sycophant and will just consume my knowledge eventually making me irrelevant. So as a warning, I will being going dark with my knowledge soon.

Power Query employs Banker's Rounding as the default, but you can override this with the RoundingMode.Up option:

Number.Round(MyNum, 2, RoundingMode.Up)

However, I have found that this is actually buggy and doesn't always work. I would post the issue to wherever PQ bug reports go, but I am not a fan of that because I got work to do, and MS takes months, if not years, to fix bugs anyway.

So, I think I found a workaround as rounding errors are often a function of floating point precision errors:

Rounding really far out first seems to fix the problem:

InitialRound = Number.Round(MyNum, 15),

FinalRound = Number.Round(InitialRound, 2, RoundingMode.Up)

HTH YMMV

[MasonMA]

Weird, how would it be possible to see the data in table view/Power Query Editor when it is DirectQuery 🤔

[Ereon]

You have to go into "Transform Data" to get a preview of the data.  I also have access to the Snowflake data table the query pulls from and can confirm that the preview data matches the Snowflake data.

[Elena_Kalina]

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.

[Ereon]

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.

[ryan_mayu]

@Ereon 

could you pls provide your pbix file?

[Ereon]

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.

[MasonMA]

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

[Ereon]

The issue is not the number of decimal places, it is that the Field consistently rounds to the dollar and drops all decimal numbers.