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.
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 !
Please add this feature
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.
Mark R. commented
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.
Patrick Harilanto Raherinjatovo commented
I just want to have an input box where user can enter a password to access a link in powerBi published in web
Abhay Puranik commented
This is a very basic feature which should be there in the tool.
Any updates on that point?
Jeff Eschright commented
Dynamic Reporting with comments. This will be a nice feature, but as data is shifted and refreshed, and filtered. how would you keep the comments for a specific record?
Important concept: Is power BI a reporting tool or a transactional tool?
-- In the interim you could create text box that people could type notes into? Other option create an Excel Log that you keep a record of all the notes. Add on idea, link the notes or log back to the report using an ID to pull those notes back in to the reporting tool.
-- Conditional formatting should allow to highlight important items by setting up thresholds.
-- Rank and top can help define issues, as well as; if you set up floor, ceilings, upper bounds and lower bounds and/or statistical analysis.
Creativity is only limited by our imagination!
Lance McKinnon commented
I understand it was responded to March 2018, but this would be a killer addition.
This can be used in many reports and change the way processes are redesigned through PowerBi. Please add! Thank you!
Paul O'Connor commented
what a disappointing response from Will Thompson. 2k+ thumbs up and no plans :(
Key element of PBi, and advertised as is the ability for diverse reporting. Not so diverse now and poor from MS here as the ability is there, you just need to extend it. you can add a search filter that takes user input! all you have to do is extend this.
You also own SQL (as MS), so allowing user input over declares also shouldn't be much of an issue to get "In the Plan".
Most frustrating and silly response i have seen in a while.
Oh well. Hope they plan it before it becomes a show stopper. i am not scripting out mass scripts or hitting my database hard just because i cant diversely get the information i need without having to pull ALL the information for PBI to then filter it.