Forum Discussion
Fields Parameter accepting incorrect input values during What-if Analysis
Hi Rajeshwar-s
This is a known issue with a single selection numeric parameter when there are many values to select from. Instead of single selection, use "Less than or equal to" and cover the grayed out area with a shape filled with a color that matches the background of the slicer.
Resolver IVI came up with a nice solution but it's not using parameters:
1. Generate a new table using the same dax query that you have. Go to the modelling tab and click on "New Table". Then just put in the generate series Dax that you have.
2. Make a slicer for the Value field (there'll only be 1 field)
3. In the slicer settings - make it greater than or equal to:
4. Make a measure like this:
If you want, you can make a little white box and put it over the greyed out max part. But this should work in pretty much the same way as you want. Just reference this measure for any other things you want to calculate.
Please mark as the solution if this solved your query.
- pbiuseruk
Use danextian's solution below - I didn't realise you can just just change the slicer setting for the parameter. For you data cards or wherever you're referencing it - just make make sure you either use Min or Max before the parameter field value (depending on if you do "Less than or equal to" or "More than or equal to").