cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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
AbelNewton
Frequent Visitor

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

GiaMetcalf
Frequent Visitor

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?

Sounds like you are looking for parameters:

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

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

v-qiuyu-msft
Community Support
Community Support

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

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.

@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

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

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.
Anonymous
Not applicable

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

 

Shelley
Continued Contributor
Continued Contributor

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
Impactful Individual
Impactful Individual

There has to be a way to hack this

Austin is VP Operations at PowerPivotPro and a professional self-service enthusiast 🙂
Greg_Deckler
Super User IV
Super User IV

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!




Anonymous
Not applicable

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

 
 

slicers.JPG

 

Shelley
Continued Contributor
Continued Contributor

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
Not applicable

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. 

 

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!




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

Sean
Community Champion
Community Champion

@Anonymous Not currently possible.

 

Are you talking about something like this?

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

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.