Forum Discussion
moesteez
Helper I
6 years agoFilter All in Power Query
Hi, quick question,
I have a table (stores) that is filtered based on a parameter (name) that a user selects when opening a template.
If I have a lot of stores, is there a shortcut I can use if the user selects my "All" option. At the moment Im writing every store name out in the query, eg
if #"Store Filter" = "All" then [Name] = "A" or [Name] = "B" or [Name] = "C"
but this is time consuming and doesn't work when new stores are added. Is there sometging else I can do?
Thanks!
Hi moesteez
this is in a table filter (Table.SelectRows), correct?
To return all rows, simple use true like so:if #"Store Filter" = "All" then truePlease not that it doesn't come in quotes, as this has to be a boolean value.
2 Replies
- amitchandak
Super User
ImkeF , Can you help?