cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vicros
Helper I
Helper I

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

 

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])

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


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG
judspud
Solution Supplier
Solution Supplier

Hi @vicros 

 

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

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!