Decimal value inputtting in What If Parameters

[harshagraj]

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.

[jeremyp78]

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?

[manikumar34]

@harshagraj , 

Not clear, 

If you are looking to input any slected value.  Try using something liket this.

Parameter = GENERATESERIES(0, 1000, 0.01)

Regards, 

Manikumar

[amitchandak · Accepted solution]

@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

[fahadnazir]

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