Skip to main content
Microsoft Idea

Power BI

Under Review

input fields

Vote (4238) 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 (254)
Power BI User's profile image Profile Picture

Prachi on 06 Jul 2020 00:03:38

RE: input fields

This is a very important and user friendly functionality and should be priortize. It will certainly increase the flexibility of analyzing data in Power BI. In Tableau we have user input parameters for the reports.

Power BI User's profile image Profile Picture

Clark Walliser on 06 Jul 2020 00:02:22

RE: input fields

At my new job I'm using Tableau, which has user input parameters for the output report.
25 years ago Crystal Reports had user input parameters.

Power BI User's profile image Profile Picture

Power BI User on 06 Jul 2020 00:02:14

RE: input fields

'@will-thompson

Hello ,

An "input filed" is very interesting for example to see a dynamic statistic in funtion of a min and max date.

To create an input field I propose this for the dax function :

> a component which accept several format type (date, datetime, hour, numeric,text, ...)
> the component save in memory a default value if the field of component is empty/voide
> in dax formula give an instruction to pass in variable for a column, the value , replace by a default value in a column if the user doesn' insert a value

Power BI User's profile image Profile Picture

Power BI User on 06 Jul 2020 00:02:14

RE: input fields

'@will-thompson

My idea with a suggestion :

Component
In option of component
[default value in column;replace value in column after input of user]

If replace value is empty/voide/null
Past default value of component in column
Else past replace value
/* default value can empty/voide/null */

Example if function of type format :
with date [01/01/1900;01/12/2019]
with datetime [01/01/1900 00:00:00;01/12/2019 12:13:14]
with hour [00:00:00;02:03:04]
with text [field_text;your_text_value]
with numeric [0;1234]

I don't know how you can past the value . It's only a suggestion. For example when you are in "online mod" with app.powerbi.com and the user can interact you dax or power query .

The dax function of input field can be like this :

inputfield(name_of_component;past_value_in_inputfield)

Power BI User's profile image Profile Picture

Siva Nallaswamy on 06 Jul 2020 00:02:06

RE: input fields

Not sure why this is pushed back even after so many votes. This opens a lot of possibilities when used with DirectQuery mode

Power BI User's profile image Profile Picture

Midani on 06 Jul 2020 00:01:58

RE: input fields

Basic features to create more specifically tailored reports. Hope it goes up more !

Power BI User's profile image Profile Picture

Power BI User on 06 Jul 2020 00:01:48

RE: input fields

Please add this feature

Power BI User's profile image Profile Picture

Power BI User on 06 Jul 2020 00:01:44

RE: input fields

Please add this feature as it is a basic feature in other tools and couldn't convince customers for simple missing features in Power BI.

Power BI User's profile image Profile Picture

Mark R. on 06 Jul 2020 00:01:35

RE: input fields

I'd love to update my reporting services to Power BI, and is the only feature that BI is lacking that prevents me from switching to it.

Power BI User's profile image Profile Picture

Patrick Harilanto Raherinjatovo on 06 Jul 2020 00:01:30

RE: input fields

I just want to have an input box where user can enter a password to access a link in powerBi published in web

Merged Idea (7)