Power BI

Planned

input fields

Vote (4309)

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 08 Oct 2024 03:13:06

Mo 10/7/2024 - This is planned

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 (256)

Derek Sparks on 06 Jul 2020 00:04:07

RE: input fields

How is this not already a feature?

gunjan on 06 Jul 2020 00:04:05

RE: input fields

Please add input filed

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.

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 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 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)