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 25 Jul 2020 23:46:00
Hi everyone. This is something we'd like to get to in the future but don't have any plans for at the moment.
- Comments (227)
RE: input fields
How is this not already a feature?
RE: input fields
Please add input filed
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.
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.
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
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)
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
RE: input fields
Basic features to create more specifically tailored reports. Hope it goes up more !
RE: input fields
Please add this feature
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.