filtering using parameters & M code

[Axsom]

If my questions seem noobish - it's only because I started with Power Query this week...
I have been able to add a couple of parameters to my queries, one allows the end user to change the month of the report they are viewing, and another to sort the "Group/Client" they are viewing.
My M code line to change the filter is: #"Filtered Rows1" = Table.SelectRows(#"Trimmed Text", each ([#"Client"] = (SortByClient)))

You can change the Group/Client using a Validation pull down list but my problem - is I can't get it to change back to "Select All"

How can I get back to the full list after using the filter?

Fingers crossed I have this in the correct forum this time...

 

[severynm]

So it sounds like you want this filter to be adjustable later on by users? If so, Power Query is the wrong location to do that; you would need to do it in a slicer inside of your actual report or with your pivot table (depending on if you are in excel or Power BI).

The filter functionality inside of PQ is more of a one-time operation to filter the entire dataset. If you want to use the entire data set, but only want to filter/drill down a specific view/chart/table in a customizable way, a slicer is what you want.

 

[Axsom]

This sounds/looks promising.
I haven't done much work with a slicer, but I will inform you how it goes...