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 (255)
- Merged Idea (7)
RE: input fields
Your filters need this option! I have millions of rows and don't want users scrolling for days to find the customer they need. Even if you just add an edit button at top of list like Excel filters would work!
RE: input fields
Wow. This kind of feature should be table stakes at this point - has been in other platforms for over a decade. I'm deploying reports to a lot of people - they need to be able to filter what they see before they ever get to the actual data.
RE: input fields
'Hi, There
I've been trying myself to make What-If params work and they do work well (partially), to these conditions:
- Should you want to use the What-If Parameter as an aggregated (fixed) value regardless the level of grouping you use in the dashboard, it works well. E.g., a % of discount, a GM%. This happens because the Parameter will only work as a measure, instead of as a column.
- Unfortunately, sometimes we want to use this parameter as a variable to compare/filter, and since it's not being defined at the row/register level, it simply won't work to filter; you'll end up comparing to the default level you assigned to the parameter when not selected.
If anyone seems to have a way to use the parameters as filter to the report, that'd be awesome.
RE: input fields
what is the workaround for the same? I want to generate report based on the date. User will enter the date and data change accordingly.
RE: input fields
I am implementing this functionality easily by using "What if Parameters":
https://docs.microsoft.com/en-us/power-bi/desktop-what-if
RE: input fields
Buttons too for more interactivity!
RE: input fields
What's the point of voting if no updates are provided
RE: input fields
This would be hugely valuable
RE: input fields
Combining this with R models would be the optimal implementation of this feature.
RE: input fields
This is an important feature. We would be able to run different scenarios. For example, users could enter different costs, margins or prices that would then be used in measures and calculate to see different scenario results for planning or project analysis purposes. This capability has been in QlikView for years and works awesome.