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

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.