Update parameter from table in excel as filter

Power Query
1

Hi. I have a one-cell table in excel which acts as a dynamic selection box for the user to choose a variable. In this case the variable is a project number.

This project number is collected via a query and is added to the data model and ends up as a list / then filter value in the query editor on the project table. This works fine.

When the user choses a new project number they press “refresh all” and the new number is sent into the query editor to filter the project table with the new selected project number. All good!

However, is it possible to get this to work without pressing “Refresh All” as each time I do this it takes approx 1 minute to run. In otherwords, is it possible to have this dynamic filter update in another way which is less time consuming?

2

The way you describe the use of the parameter, it sounds as if you need instead a simple filter.
So instead of restricting the data per parameter to only one single project get the data for all projects and use a filter to select the project (or projects).

That sounds as you are working in Excel, which would offer you the possibility to do the filtering with slicers: Slicers work great with pivots AND with tables.

1 Like
3

Hi Matthias, thanks a lot for your reply. Actually I ended up using a solution very similar to that you describe. Thanks again

1 Like