Filter a table by a parameter

[JGARROD]

Hi, 

I have a table which is being profilied, as such another table has been created which does a number of thing such as count distinct, distributon of value etc for all columns of the underlying table. I need to be able to initially filter the underlying table (there is one column called Stautus which is active/inactive). I think i need to use parameters and a filter on said (inactive/active) column. However i want the user to be able to select Active or Inactive or 'Both' and then for it to filter the tbale however i dont know how to get the parameter to pass the wildcard of 'both inactive or active' to the column filter. 

Any help would be much apprecited. 

[JGARROD]

Yep this was it, it came to me when i tried to use numbers rather than words and also the 'CONTAINED' so ive ended up with a column with two values 'All Active, All Inactive' and then a Parameter with 3 values : All, All Inactive, All Active. 

By using the contains on the filter i can filter by All, or by individual. 

[ToddChitt · Accepted solution]

I have never tried this so just guessing here:

Add a derived column in Power Query and concatenate the Status column with the literal ", Both" so now that column contains values like "Active, Both" or "Inactive, Both". Filter on that column with a CONTAINS comparison against the Parameter value. 

This may fail depending on if the comparison engine thinks that "Active" is CONTAINED in "Inactive, Both" even though it is a capital A versus a small a. But I *think* Power Query is CASE Sensitive.

Try it and let us know how it goes.