Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
jarnone
Regular Visitor

Unwanted Rounding Issue

Hoping someone can please help with this weird issue. I've got a large data set with many columns that include numbers with two decimals. They all import as expected except for one column that rounds to the nearest whole number. 

 

I've tried everything I know of. I adjusted the Rounding settings. I've marked the column as Decimal, Fixed Decimal, Currency... Nothing has worked. It rounds this column no matter what I do. I've tried adjusting the settings on the column in excel before importing to see if this works either. 

 

I'm stumped... 

 

 

1 ACCEPTED SOLUTION
jarnone
Regular Visitor

UPDATE

 

So I found a workaround. Not an actual solution, but at least it worked... I created a new Column that equals the values of the Column with the rounding issue. The new Column did not round the values. 

 

So this workaround was successful. I'm still not happy with the bugginess and the inability to resolve it properly though. Stumped...

View solution in original post

7 REPLIES 7
Cornwalls
Helper I
Helper I

Also having a weird rounding issue. My visual just will not show the actual value that it should be. It should show 0.5 but no matter what it stays at 1.0. Randomly it changed to 0.5 last night so thought it was fixed, then this morning it has gone back to 1.0.

 

Visual:

Cornwalls_2-1711512018370.png

 


Imported Dataset (Sharepoint List) says 0.5:

Cornwalls_0-1711511597716.png

The PBI says it correctly in the transform data:

Cornwalls_1-1711511694942.png

 

I have tried creating a new column as suggested by the OP, that unfortunately didnt work in my case - is there any direct Formatting in the Visual itself to stop rounding numbers?

 

 

 

 

 

 

This is the first time I've heard of anyone else having the same issue! It's a frustrating issue. I received a lot of advice, but it was all simplistic solutions that did not work. I'm convinced it's a Microsoft glitch that no one has resolved yet. It's not something you are doing wrong!

 

The data set I use has dozens of two-decimal columns, which when imported, do not round. There was always one consistently rounded column no matter what I tried.

 

My solution was a work-around. I added a column in the Excel data doc that equals the corresponding cells. This imports fine and has been working fine for months. It's not an ideal solution, but it works... 

 

Hope your issue raises enough concerns with Microsoft for them to actually research the issue instead of doling out obvious advice. 

jarnone
Regular Visitor

UPDATE

 

So I found a workaround. Not an actual solution, but at least it worked... I created a new Column that equals the values of the Column with the rounding issue. The new Column did not round the values. 

 

So this workaround was successful. I'm still not happy with the bugginess and the inability to resolve it properly though. Stumped...

grazitti_sapna
Resolver I
Resolver I

Hi @jarnone
You can achieve it by many ways:- 
One of them mentioned by @vicky_ 

Rounding in the Source Data:

  • Examine the source data in its original form (before importing into Power BI). If the data is already rounded in the source, Power BI will import it as such.

Check Data Type in Source:

  • Ensure that the column in your source data (e.g., Excel file) is formatted as a decimal with two decimals. Excel, for instance, has its own cell formatting settings, and sometimes those settings can affect how data is imported into Power BI.

DAX Calculations:

  • Check if there are any DAX calculations in your Power BI model that might be rounding the values. Look for ROUND or ROUNDUP/ROUNDDOWN functions in your measures.

Let me know if any one of these works.
Thanks 

jarnone
Regular Visitor

Yes, I've tried those configurations as well. Tried many different combinations, unfortunately none have worked. Thanks though. 

vicky_
Super User
Super User

As a sort of last-ditch effort, once the data has loaded into powerBI, try check that the format of the column is not set to whole number (and that the decimal places column is not 0)

vicky__0-1705356180494.png

 

Thank you. Tried all of those possible options as well. I've tried all the possible decimal and percedntage options in the column settings. And I've also check to ensure there's no DAX rounding formula behind the scenes. 

 

I'm still stumped... 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.