Forum Discussion
benz-fsproduce
3 years agoFrequent Visitor
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
- lbendlinSuper User
In your Power Query check for earlier steps that set the column as whole number. Remove those steps.