Can we add user input field on Report

[Anonymous]

Hi All,

Can we add user input field on report and do calculation  ? Free Form on Report.

Ex :  2 + 5 - 4 =  3 

2 and 5  is a user input box on the report and 4 is pulled from database.  Can we achieve this? 

 Thank you 🙂

[AbelNewton]

I am late. But What-If parameter may be what you were looking for. 

[GiaMetcalf]

Hi - a simple question.  Is there a way in Power BI to define input fields (I.E.begin and end date ranges).  When the report is published, allow the user to input a date range and then generate the report based on these input parameters?

[ImkeF]

Sounds like you are looking for parameters:

http://biinsight.com/power-bi-desktop-query-parameters-part-1/

[Anonymous]

Saw this post in 2022 and am an avid reader of your blogs- just wanted to say thank you for all your contributions over the years with Power BI - you have really helped me (and others I am sure!) in solving some complex problems. Wish you best for the future. 

[v-qiuyu-msft]

Hi @Anonymous,

I agree with @Sean. Currently, the feature about inputting values in a report is not supported. Please vote on this idea item mentioned by Sean: input fields . In addition, I already reported the issue internally, will keep you update once I get any updates.

If you have any question, please feel free to ask.

Best Regards,
Qiuyun Yu

[ImkeF]

@v-qiuyu-msft

Would be interested to see where you see the differences between the parameter-features within the last release I've mentioned and the request you've forwarded. Both do (request) exactly the same in my eyes:

Taking user input and placing it at the desired places in the queries/code in order to filter or parametrize the output.

[v-qiuyu-msft]

Hi @ImkeF,

In Power BI Desktop April update version, values for query parameters are pre-defined in Query Editor, still no way to input values at runtime.

Howeve, what I think @Anonymous's requirement is input values in report, while query parameters can't achieve this goal.

Best Regards,

Qiuyun Yu

[Anonymous]

@Qiuyun_Y : I Agree with you , Parameter can NOT solve the user input Free Form. Thanks

[Shelley]

I agree too. Parameters are not the same and would be cumbersome compared to entering values directly in the report, allowing quick scenarios input one after another.

[austinsense]

There has to be a way to hack this

[Greg_Deckler]

You might be able to pull it off with a combination of slicers, but not free form like that. So make the first two numbers slicers to tables of numbers and then write a measure that does a SUM from each of those tables. and then the rest of the calculation.

[Anonymous]

I've used this where the input fields are limited. These figures are then used for calculations elsewhere on the page looking at headcount.

[Shelley]

Yes, good idea. I've done this too. For example, one of our sales teams wants to create new sales goals for the year for our distributors, I have a Growth Goal drop-down, which lists all options from 0 to 100% and they can select the one they want and see how it impacts all the goals calculations in the report. It works pretty well, but they are limited to entering only what is included in the table for selection. Works good for this, but may be tougher in a situation that requires a lot of granularity or really specific numbers.

[Anonymous]

Hi Smoupre, If i correctly understand i should create a Slicer with Tables of numbers (pre-populated numbers i your column) ?

But still user will not be able to enter the Real number e.g 2.7 + 3.9 , as this is a financial report.

Any other solution ? 

Is it possible if i can create small what-if analysis table in Excel and upload on Report and hence in PBI Service ? Will this work. 

[Greg_Deckler]

Might if you connect it.

[ImkeF]

In the latest PBI-update they've shipped parameter support as well: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-april-update-feature-summary/?utm_content=...

[Sean]

@Anonymous Not currently possible.

Are you talking about something like this?

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9414921-input-fields