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.
Solved! Go to Solution.
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.
If you want to sepefic list in the parameter, Power BI can't support the feature until now. You can create a idea here.
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
Yes, I reproduce your scenario. Your understanding is right, as when you click the ! button on the left above, it shows the following tips.
Please mark your reply as answer, so more people will benefit from here.
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?