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 ,
We would like to follow up to see if the solution provided by the user resolved your issue. Please let us know if you need any further assistance.
If the provided response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.
Regards,
Chaithra.