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
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.