cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper V
Helper V

Can we add user input field on Report

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 🙂

16 REPLIES 16
Highlighted
Community Champion
Community Champion

Re: Can we add user input field on Report

@mridul Not currently possible.

 

Are you talking about something like this?

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

Highlighted
Super User IX
Super User IX

Re: Can we add user input field on Report

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.


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Helper V
Helper V

Re: Can we add user input field on Report

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. 

 

Highlighted
Super User IX
Super User IX

Re: Can we add user input field on Report

Might if you connect it.


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Super User IV
Super User IV

Re: Can we add user input field on Report

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=...

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

Highlighted
Community Support
Community Support

Re: Can we add user input field on Report

Hi @mridul,

 

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Super User IV
Super User IV

Re: Can we add user input field on Report

@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.

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

Highlighted
Community Support
Community Support

Re: Can we add user input field on Report

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 @mridul's requirement is input values in report, while query parameters can't achieve this goal.

 

Best Regards,

Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Helper V
Helper V

Re: Can we add user input field on Report

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

 

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors