Forum Discussion

benz-fsproduce's avatar
benz-fsproduce
Frequent Visitor
3 years ago

Rounded numbers

I am working on a report that shows the satisfaction score for a list of companies. The numbers on my excel sheet are formatted as a decimal. When they go into PBI the numbers are all rounded up to 1. I have changed the data type to decimal number and percentage in Power Query with no luck. I have looked through forums of those who have had similair issues, but they have not helped to fix mine. I have inserted a screenshot of my Powerbi as well as my data source. Thanks!  

 

 

1 Reply

  • In your Power Query check for earlier steps that set the column as whole number. Remove those steps.