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

What if parameter help - input changes by itself after hitting enter

I set the what if parameter to range from 1000 to 5500, with increment of 1.  Because of the way that I am using the what if parameter, I need the user to input a specific number, and not just use the slider.  

The problem is that sometimes, only sometimes, the number changes after I put it in. Why is this happening??? So for example, if I put in 3080, it automatically becomes 3079. Sometimes the change is from say from 4151 to 4149.  

 I included a video of this problem here: https://mediaspace.wisc.edu/media/What+if+Parameter+Problem/1_47no0vpf

 

Does anyone know what this is happening?

 

Another way to solve the problem is if anyone knows how I can input a list in the what if parameter. That'll solve the problem.

1 ACCEPTED SOLUTION

@v-huizhn-msft Did you set the range as the same as mine? I think it's because of the range being too big and the numbers are being sampled.

View solution in original post

12 REPLIES 12
dhritimanpal
Frequent Visitor

Any resolution to this issue?

 

I got the same issue. Don't know why a simple issue was not fixed for a long time.

DataZoe
Super User II
Super User II

(not sure if my earlier response went through so posting again)

 

To get around this behavior what I do is change the slicer box the input value is in to a dropdown or list. This way every possible value is shown and when you click one of them it comes through exactly.

 

For a larger range, I do this but also put the input value in the filter pane. From the filter pane you can choose an exact value or a range of values for the input value. That way you can limit it to a range of values then bounce around a bit within that range using the dropdown or list.

 

For example, if you have an input range of 1 to 10,000, you can go to the filter pane and limit the range to 1 to 20. Then the dropdown or list will only show those 20 values to choose from.

Respectfully,
DataZoe


See my reports and blog at https://www.datazoepowerbi.com/

ozbroomy
Helper I
Helper I

 

I am also experiencing this issue. My value range is 1 to 5000 with an increment of 1. Is this too much?
Using whatif has privided an almost perfect solution I was after for the ROI Calculator shown below, but is unusable in front of a client due to this bug. Is there a plan to resolve this?

 

ROI_WhatIf_Bug_2018-06-07_1106.png

yes that's about the range i used and yes it's too big for Power BI to handle precisely.

v-huizhn-msft
Microsoft
Microsoft

Hi @xizhouxie,

If you want to decrease 1 from the selected value in parameter. When you create a what-if parameter, which generates a table named "Parameter", and a measure [Parameter Value]. You can create another measure using the formula using the formula below.

decrease1 = Parameter[Parameter Value]-1


Please see the screenshot, when I select 3 in parameter, the measure returns 3.

1.PNG

If you want to sepefic list in the parameter, Power BI can't support the feature until now. You can create a idea here.

Best Regards,
Angelia

This parameter problem is still an issue in 2021.   Impossible to use the parameter slider to go by $1.00 increments when dealing with large number ranges.   This really needs to be fixed.  

Hi @v-huizhn-msft

 

No I don't want to decrese 1 from the selected value. It does that by itself! I want the selected value. It seems to be a bug to me.

A video of what I'm talking about : https://mediaspace.wisc.edu/media/What+if+Parameter+Problem/1_47no0vpf

 

Hi @xizhouxie,

It's really weird, I didn't reproduce it. What's your desktop version? Please update your BI desktop the latest and check if it works fine.

Best Regards,
Angelia

@v-huizhn-msft Did you set the range as the same as mine? I think it's because of the range being too big and the numbers are being sampled.

View solution in original post

Hi @xizhouxie,

Yes, I reproduce your scenario. Your understanding is right, as when you click the ! button on the left above, it shows the following tips.

1.PNG
Please mark your reply as answer, so more people will benefit from here.

Best Regards,
Angelia

I hope Power BI increases the range soon! @v-huizhn-msft

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

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

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors