Forum Discussion
Solved
Parameter (decimal) resolving to incorrect value
Hi all So, my problem is that my parameter is resolving to a value different than that entered. parameter is GENERATESERIES(0, 1, 0.0001) When I enter 0.0714 (7.14%) it resolves to 0.0709 (7...
What you're seeing is likely due to floating point precision issues. Power BI sometimes stores decimal numbers in binary format, which can cause small rounding errors – especially with values like 0.0714.
Here are a few things you can try:
- Use ROUND([YourParameter], 4) in DAX to force the value to 4 decimal places.
- In Power Query, apply Number.Round(YourParameter, 4) to clean it up before it hits the model.
- Make sure the parameter is set as Decimal Number, not Fixed Decimal, and formatted to 4 decimal places.
- As a workaround, you can also input the value as text and convert it using VALUE("0.0714").
translation and formatting supported by AI
Hi jmont031 ,
If the provided answer was helpful, please mark it as "Accept as solution" and click "Yes" if you found it helpful, it will be helpful for other members of the community who have similar problems as yours to solve it faster.
Regards,
Chaithra.