Forum Discussion
Post PartisanDecimal value inputtting in What If Parameters
Hello All,
User requirement is to have a input box in Sheet1 and Needs to display the inputted value in Sheet2 as a card.
I tried creating a what if paramater but user needs to inuput different values like 2.35,83.62,98.39 etc. But in what if parameter if i enter those values it is correcting to something else.
Please help me.
harshagraj , You can generate a series of your choice. Make it like generate series (0.00,100.00 ,0.01) , then you will be able to choose
refer my example of quick measures : https://community.powerbi.com/t5/Quick-Measures-Gallery/PMT-Monthly-EMI-Calculator/td-p/1232245
4 Replies
- amitchandak
Super User
harshagraj , You can generate a series of your choice. Make it like generate series (0.00,100.00 ,0.01) , then you will be able to choose
refer my example of quick measures : https://community.powerbi.com/t5/Quick-Measures-Gallery/PMT-Monthly-EMI-Calculator/td-p/1232245
Hi amitchandak I used the same parameters you suggested in generateseries but my number changes to a long decimal automatically.
9.9 becomes 9.889999999
10.25 becomes 10.289999999999825
Please suggest
- manikumar34
Solution Sage
Not clear,
If you are looking to input any slected value. Try using something liket this.
Parameter = GENERATESERIES(0, 1000, 0.01)Regards,
Manikumar
Did you ever find a solution for this? I'm having the same issue. If I generate a series like this:
SimilatedLabourRate = GENERATESERIES(100.00, 250.00, 0.01) it seems to generate fine, however if the slicer is a "Single Value" style where the user can enter a number like 102.00 it will change the value to 101.95!! If I change the slicer to a dropdown, it works when the user selects the number, but that's not a good workaround for me since there's way too many options and the user has to constantly scroll through the list. Has anyone else figured out why this doesn't work as it should?
