cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
schwartauextra
New Member

what-if parameter changes my input

Well known issue:

 

what-if parameter, p:
p = GENERATESERIES(0, 400, 0.01)

 

--> Problem: The selected value will be rounded up or down

 

The problem seems to be fixed for whole numbers, is there a workarround for decimals?

 

(I know the input should be limited to 1000 Values but it is not possible for calculation)

1 ACCEPTED SOLUTION
selimovd
Super User
Super User

Hey @schwartauextra ,

 

that's because you have more than 1002 values. Then it will take random values in the whole range.

Check the following article on what exactly is the problems and what alternatives are there:

Why is it sometimes not possible to select the exact number in the what-if parameter and how can thi...

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 

View solution in original post

3 REPLIES 3
schwartauextra
New Member

I have solved this issue based on Denis suggested solution and attached a Rounddown function to it. This means if a user will input 5.00 the float might round up to 5.01 in any visual. To avoid that and other issues I use the rounddown(min(input),2)
--> 5.00 

schwartauextra
New Member

Thank you Denis for your quick reply.

Great link! 
If I use your 2. option of the suggested solution and change the type of slicer to "Less than or equal to" the problem still occurs. 

123.JPG



selimovd
Super User
Super User

Hey @schwartauextra ,

 

that's because you have more than 1002 values. Then it will take random values in the whole range.

Check the following article on what exactly is the problems and what alternatives are there:

Why is it sometimes not possible to select the exact number in the what-if parameter and how can thi...

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 

View solution in original post

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

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

Top Solution Authors
Top Kudoed Authors