Skip to main content

Power BI

Under Review

input fields

Vote (4247) 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

Jade on 05 Jul 2020 23:21:42

RE: input fields

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!

Power BI User's profile image Profile Picture

Power BI User on 05 Jul 2020 23:19:49

RE: input fields

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.

Power BI User's profile image Profile Picture

Javier Chacon on 05 Jul 2020 23:18:02

RE: input fields

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

Power BI User's profile image Profile Picture

Ashutosh Trivedi on 05 Jul 2020 23:17:06

RE: input fields

what is the workaround for the same? I want to generate report based on the date. User will enter the date and data change accordingly.

Power BI User's profile image Profile Picture

Power BI User on 05 Jul 2020 23:17:03

RE: input fields

I am implementing this functionality easily by using "What if Parameters":

https://docs.microsoft.com/en-us/power-bi/desktop-what-if

Power BI User's profile image Profile Picture

Grant Weaver on 05 Jul 2020 23:15:54

RE: input fields

Buttons too for more interactivity!

Power BI User's profile image Profile Picture

Dan on 05 Jul 2020 23:15:12

RE: input fields

What's the point of voting if no updates are provided

Power BI User's profile image Profile Picture

Robbie Francis on 05 Jul 2020 23:14:33

RE: input fields

This would be hugely valuable

Power BI User's profile image Profile Picture

Onno Dijt on 05 Jul 2020 23:14:08

RE: input fields

Combining this with R models would be the optimal implementation of this feature.

Power BI User's profile image Profile Picture

Shelley on 05 Jul 2020 23:13:42

RE: input fields

This is an important feature. We would be able to run different scenarios. For example, users could enter different costs, margins or prices that would then be used in measures and calculate to see different scenario results for planning or project analysis purposes. This capability has been in QlikView for years and works awesome.

Merged Idea (7)