Forum Discussion

moesteez's avatar
moesteez
Helper I
6 years ago
Solved

Filter 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 ...
Need Help
  • ImkeF's avatar
    ImkeF
    6 years ago

    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 true

     

    Please not that it doesn't come in quotes, as this has to be a boolean value.

     

ImkeF's avatar
ImkeF
Community Champion
6 years ago

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 true

 

Please not that it doesn't come in quotes, as this has to be a boolean value.