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
Cornwalls
Helper I
Helper I

Weird rounding issue

I am having a weird rounding issue. My visual will not show the actual value that is in the dataset.

The expected value it should show i the visual is 0.5 - but no matter what i try it stays at 1.0. I have tried changing the formatting in the data source and in the dataset, added decimal places to 2. Tried a custom column and tried creating a new visual. I believe it was changing the decimal places to 2 that fixed it last night but today in trying that its not budging.  

 

Visual (displaying incorrectly):

Cornwalls_2-1711512018370.png

 


Datasource (Sharepoint List) displays correctly and says 0.5:

Cornwalls_0-1711511597716.png

Dataset (displays correctly 0.5):

Cornwalls_1-1711511694942.png

 

Any help would be greatly appreciated!!!

 

 

 

 

 

 

1 ACCEPTED SOLUTION
christinepayton
Super User
Super User

In Power Query, is it being set to whole number type? Sometimes with the auto-type assignment if it only finds whole numbers in the first x rows it'll do that and you have to manually go change it to decimal in that first change-type step in Power Query. If it's whole number and you've added decimal places, it would present as you describe. 🙂

View solution in original post

2 REPLIES 2
Cornwalls
Helper I
Helper I

Thank you a million @christinepayton ! waking up this morning and switching one of the columns from whole number to decimal number again coupled with with the setting 2 decimal places seems to have fixed it!

 

I cant say i understand the logic, i only changed whole number to decimal number on one column however it applied the fix across all four columns - so three columns are still set to whole number yet they all changed upon changing one column to decimal number. 

christinepayton
Super User
Super User

In Power Query, is it being set to whole number type? Sometimes with the auto-type assignment if it only finds whole numbers in the first x rows it'll do that and you have to manually go change it to decimal in that first change-type step in Power Query. If it's whole number and you've added decimal places, it would present as you describe. 🙂

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors