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.
(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.
See my reports and blog at https://www.datazoepowerbi.com/
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?
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.
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.
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.
Check out the News & Announcements to learn more.
Microsoft received the highest score of any vendor in both the strategy and current offering categories.
Mark your calendars and join us for our next Power BI Dev Camp!
Check out our new Discover Your Career Path blog post series and get all the details.