Forum Discussion

jmont031's avatar
jmont031
Frequent Visitor
1 year ago
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...
Need Help
  • burakkaragoz's avatar
    burakkaragoz
    1 year ago

    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:

    1. Use ROUND([YourParameter], 4) in DAX to force the value to 4 decimal places.
    2. In Power Query, apply Number.Round(YourParameter, 4) to clean it up before it hits the model.
    3. Make sure the parameter is set as Decimal Number, not Fixed Decimal, and formatted to 4 decimal places.
    4. As a workaround, you can also input the value as text and convert it using VALUE("0.0714").
      translation and formatting supported by AI