Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi guys,
Seeking your help to solve this problem. I have a data set in Excel format which I update monthly and refresh Power BI report to fetch data. Other months were fine, but starting from Sep, there was missing data due to decimal points.
Double-checking my Excel data, there was no round-up. Hence I'm uncertain why Power BI doesn't accept decimal and auto round-up numbers? How can I fix this to have the exact numbers as my Excel data?
Thanks much for your help!
Solved! Go to Solution.
Hi, @milkynight
Can you share relevant screenshots about the 'Applied Steps'?
Have you checked the column data in the step of 'Navigation'?
I suspect that your data has lost accuracy in step 'changed Type'. When you export data, please consider deleting the existing original steps 'Changed type' and then change the data type in step 'Navigation' again to build your own step 'Changed Type'.
Best Regards,
Community Support Team _ Eason
Hi. Did you get teh solution? Because i faced the same problem.
Hi, @milkynight
Can you tell me if your problem is solved?
If you still need help, please share more information about it.
Best Regards,
Community Support Team _ Eason
Little count of context, But is your excel data in table format ?
Yes Data type is Decimal as seen in below screenshot. But you can see that Sep, Oct and Nov are imported without decimal compared to previous months... 😞
Hi.. did you find a solution to this. I am experiencing the same issue.:(
Hi, @milkynight
Can you share relevant screenshots about the 'Applied Steps'?
Have you checked the column data in the step of 'Navigation'?
I suspect that your data has lost accuracy in step 'changed Type'. When you export data, please consider deleting the existing original steps 'Changed type' and then change the data type in step 'Navigation' again to build your own step 'Changed Type'.
Best Regards,
Community Support Team _ Eason
@milkynight , please open power query and check, Data type should be decimal not fixed decimal or whole number.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |