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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.