Skip to main content

Power BI

Under Review

input fields

Vote (4294) Share
Power BI User's profile image

Power BI User on 20 Aug 2015 23:29:33

What about adding input fields to the dashboard widgets. Kind of like the text field but it is enabled for user input. This input field can be used in new column and new measure fields so that once the dashboard is set up the user can easily (without filtering) explore the data by entering different values such as if you had an input box for unit price. Then if you change it all the charts of total sales, revenue, etc. Will update to reflect what would happen if you increase the price by 10%. This will enable people to quickly and easily interrogate the data

Administrator on 21 Oct 2022 02:41:16

Thanks for the feedback! This is something we'd like to get to in the future but don't have any plans for at the moment. We suggest checking out the visual Text filter on AppSource in the interim.

Comments (255)
Power BI User's profile image Profile Picture

Sireesha on 05 Jul 2020 22:57:45

RE: input fields

Need parameter functionality just like in SSRS.

Power BI User's profile image Profile Picture

David Manley on 05 Jul 2020 22:57:02

RE: input fields

To put a finer point on the suggestion. I would like to see a column or range of empty cells (like in Excel) where values can be pasted by a user, that in turn filters the database providing a pivot table like results.
I built a tool in Excel that does just that. It provides a named range, that a user pastes "skus" into, up to 200, then clicks a button that runs a macro, filtering a pivot table field of "skus" The data source is a static worksheet in the workbook that was created in another tool joining two data sources. If Power BI could do the "macro" part that would be ideal.
Our company, HPE Software is using POWER BI more and more for our analytics and I would like to as well. Thanks. dkmanley

Power BI User's profile image Profile Picture

Stephen Hartman on 05 Jul 2020 22:56:30

RE: input fields

Would very much like to see this feature.

Power BI User's profile image Profile Picture

Power BI User on 05 Jul 2020 22:55:28

RE: input fields

This would be exceptionally useful. I am looking at relative weightings of data, and it would be brilliant to allow users to experiment with their own weightings - the input weightings on screen and the formulae use them to display alternative results.

Power BI User's profile image Profile Picture

Power BI User on 05 Jul 2020 22:53:59

RE: input fields

There should be variables that can be defined during refresh and the altered by users using sliders/input fields. And then various measures or other references to hardcoided variables can just reference $variableName

Power BI User's profile image Profile Picture

Javier Recasens on 05 Jul 2020 22:53:02

RE: input fields

Merge this idea with tabular write back

Power BI User's profile image Profile Picture

Gowtham Veera Raghavan on 05 Jul 2020 22:52:55

RE: input fields

Any update on this ?

Power BI User's profile image Profile Picture

Axel on 05 Jul 2020 22:52:09

RE: input fields

That would help to drive our business. Thanks in advance

Power BI User's profile image Profile Picture

Sam on 05 Jul 2020 22:51:54

RE: input fields

This feature request needs to get higher in the queue. Without a textbox styled free-form slicer, the what-if type of analysis becomes hard to implement. Example: a portfolio manager would wan to see what the returns might look like (based on historical performance of course) when a certain percentage of fund(s) is applied to the portfolio. I can't use a slider or a pre-populated list of percentages to enable such type of analysis.

Power BI User's profile image Profile Picture

Filious Louis on 05 Jul 2020 22:50:49

RE: input fields

Any updates? This'll be very useful for what if analysis and Top X charts.

Merged Idea (7)