Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
Anonymous
Not applicable

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 advanceperce.PNG

 

1 ACCEPTED SOLUTION
judspud
Solution Supplier
Solution Supplier

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

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

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])
Anonymous
Not applicable

@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.

judspud
Solution Supplier
Solution Supplier

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

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

February Power BI Update Carousel

Power BI Monthly Update - February 2026

Check out the February 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.