Forum Discussion
Text box for input
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?
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
Wish it is helpful for you!
Best Regards
Lucien
3 Replies
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
Wish it is helpful for you!
Best Regards
Lucien
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,
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
