cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vicros Frequent Visitor
Frequent Visitor

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

Accepted Solutions
judspud Member
Member

Re: What if parameter - wrong percentage

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
judspud Member
Member

Re: What if parameter - wrong percentage

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

Super User
Super User

Re: What if parameter - wrong percentage

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


Near SE WI? Join our PUG Milwaukee Brew City PUG
MbuitA New Member
New Member

Re: What if parameter - wrong percentage

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

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 55 members 1,292 guests
Please welcome our newest community members: