Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

What if parameter - wrong percentage

I have set up my what if parameters and now have fields where users may add the percentage which they require.  However, when I add, for example, 0.14865  , the Power BI field defaults back to 0.1489  which is incorrect.

 

Is there any way to fix this? Thanks in advance

 

Need Help
  • judspud's avatar
    judspud
    7 years ago

    Hi Anonymous 

     

    To my understanding the maximum number of decimal points you can increment in a parameter is 4. 

    I think your rounding error is due to the formatting of the value within your parameter.

    Try selecting the paramater value and changing the number of decimal places from auto to 4.

     

    Hope this helps

     

    Thanks,

    George

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Anonymous Just to add, you can do that under the "Modeling" section under "Formatting" There is a dropdown that allows you to configure that format to the number of decimal places you want.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I have got the same problem but then with whole numbers.
    For example, I'm typing 104 and it gives 105, when typing 103 I'm getting 102.

     

    What is going wrong ?

     

    TEST1 = GENERATESERIES(0; 3000; 1)
    TEST Value = SELECTEDVALUE('TEST'[TEST1])


    This does work: (but I want to ad values varying from 1 tot 4 diggits number)

    TEST1 = GENERATESERIES(0; 999; 1)
    TEST Value = SELECTEDVALUE('TEST'[TEST1])
  • judspud's avatar
    judspud
    Solution Supplier
    7 years ago

    Hi Anonymous 

     

    To my understanding the maximum number of decimal points you can increment in a parameter is 4. 

    I think your rounding error is due to the formatting of the value within your parameter.

    Try selecting the paramater value and changing the number of decimal places from auto to 4.

     

    Hope this helps

     

    Thanks,

    George