cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
siddrow
Helper II
Helper II

Long decimal values not rounding correctly

Hi

I have two decimal values in my dataset that aren't showing correctly. I believe it's due to the length of decimal places. See below screenshot of the original custom column calculation. The custom column calculates from two other columns - one is decimal value format with 2 decimal places and the other column is whole number format.

siddrow_0-1669780991768.png

 

you can see at the very bottom of this screenshot that is has many decimal values. 

 

I have tried to use the "round off" function in the transform tab, however it's not fixing the issues.

 

siddrow_1-1669781084522.png

 

I have also tried to change it in the data tab which seemed to have worked.

 

siddrow_2-1669781162602.png

 

However, when I use it in my chart visual, it is still showing weird values, even though I have selected on the visual to show 5 decimal places only. The value for the first one should show 0.00004 and the second should be 0.00007

siddrow_3-1669781233653.png

siddrow_4-1669781301582.png

 

How do I fix these value issues?

 

thanks in advance for your help! 🙂

 

 

 

1 REPLY 1
amitchandak
Super User
Super User

@siddrow , Make sure the data type in power query is also decimal.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.