input fields

[elizabeth_j_zeh]

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

[jtovar1988]

I am implementing this functionality easily by using "What if Parameters": https://docs.microsoft.com/en-us/power-bi/desktop-what-if

[javier_chacon_b]

'Hi, There I've been trying myself to make What-If params work and they do work well (partially), to these conditions: - Should you want to use the What-If Parameter as an aggregated (fixed) value regardless the level of grouping you use in the dashboard, it works well. E.g., a % of discount, a GM%. This happens because the Parameter will only work as a measure, instead of as a column. - Unfortunately, sometimes we want to use this parameter as a variable to compare/filter, and since it's not being defined at the row/register level, it simply won't work to filter; you'll end up comparing to the default level you assigned to the parameter when not selected. If anyone seems to have a way to use the parameters as filter to the report, that'd be awesome.

[dkerr1]

Wow. This kind of feature should be table stakes at this point - has been in other platforms for over a decade. I'm deploying reports to a lot of people - they need to be able to filter what they see before they ever get to the actual data.

[jknapp3]

Your filters need this option! I have millions of rows and don't want users scrolling for days to find the customer they need. Even if you just add an edit button at top of list like Excel filters would work!

[ngomez1]

Hello, yes we need it

[Michael_Hughes]

This is such a fantastic idea, I have been searching for a long time to do this in a creative fashion to no avail! Please MS!

[paulquirke79]

Need this so badly

[axdanie]

This is very much needed to make PBI more of an Analytics tool rather than just a visualisation tool. Tableau and Qlik has this as a standard feature. Can we please have this on priority - it has got the votes!

[ubiquitousdude]

I wholeheartedly agree with this, but I would also add that the user input field be used as the query parameter to run a SQL query against a CosmosDB database, and then the results are visualized back to Power BI.

[lubhit]

I too support having some user input field as parameter being used across queries. please add this but not only for PowerBI, but also for powerquery and powerpivot or simple excel interface as well.