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
Hi everyone. This is something we’d like to get to in the future but don’t have any plans for at the moment.
This lack of functionality coupled with the inability to export report/dashboard comments y hinders our use of PBI as an end-to-end tool. We are continually having to export to excel or Ppt to get a management end product.
It also significantly limits senior management engagement and challenges effectiveness of self serve as an analytical output beyond operational reporting.
I did come up with a way to already do this in my dashboard.
For example, I can look at sales and see what happens if i increase Price, Cost or Qty per a certain amount.
It's about time Power BI has this important feature. Thanks.
Seriously limiting what we can do as a organisation, please add
Any updates on it?
steve goodwin commented
We have got so many applications that this would be useful for. It would be great to get this functionality introduced soon
Sunil Kadimdiwan commented
Will be very useful to have
Highly useful !!
Brett Watson commented
I have several SSRS reports that use input fields. I've been asked to convert these reports to Power BI. Without the user input fields this is going to be difficult and I will also need to redesign how the reports work.
Any idea if this is being considered for Power BI or is this an unrealistic hope.
This would be extremely helpful! And soon! Currently prevented from converting other work to PBI because of the difficulty involved in getting at a less than ideal solution.
Kathy McEwen commented
This feature would enable development of a very Sophisticated modeling, reporting and user information gathering tool to fully exploit the powerful capabilities of PowerBI vs ongoing usage of Excel as the alternative. Think of adding a calculated column of user input, as well as individual fields, and then a button to activate column over rides. I have the ongoing need/application for this, and it’s only growing.
Unfortunately, MS seems much more focused on making reports pretty than on making the tool work in a reasonable manner!
Derek Sparks commented
How is this not already a feature?
Please add input filed
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 commented
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.
My idea with a suggestion :
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 :
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
Siva Nallaswamy commented
Not sure why this is pushed back even after so many votes. This opens a lot of possibilities when used with DirectQuery mode
Basic features to create more specifically tailored reports. Hope it goes up more !