Text box for input

[Anonymous]

I have a requirement to give a text box input (Numeric only) Whatever is mentioned in that text boc the calculation gets updated.

Lets say i show in the report calulcation as A*X.

X is the value retrived in text box. Currently i achieved this by drop down with limited values.

Any way we can do this using text box?

[Ramanabalaji]

Actually we have limitation for that column. i have requirement like based on the input number which i give in text box then it calculate with other calculated column.

Eg: company have some default number to calculate with their profit %

cal 1= (unit price * Quantity)-(mis)

anticipated portfolio = 14500000000 (input parameter value)

cal 2 = cal 1 / anticipated portfolio

Answer be like...45.98 or something

the problem here is we can't give more than 9 digits in the whatif parameter. Details available in the picture

[v-luwang-msft · Accepted solution]

Hi @Anonymous ,

As far as I know, the what if parameter is currently the best approach, and you can find the steps in the following article.

2 Easy Steps to Creating User Input Variables with Power BI

And the similar question:

Custom visual numeric input box?

Power BI User Input for change value dynamically

Text box to retrieve data

Wish it is helpful for you!

Best Regards

Lucien

[HashamNiaz]

Hi !

Please try using What-If paremter, you can define a min, max & default walue for the paramter. User can pick the value from slicer & you can use the value in your calculation.

Regards,