Select all values parameter in Power Query

[ecoquelet]

Hello !

I have some data that I need to be able to filter by country. So, I've created a parameter for it by getting a list of distinct values from the Country column, then I modified the query in editor by placing the parameter name in filtering step.

This works fine, however I'm wondering :

Are there any possibility to get an option of selecting all the values from the list of countries or desactivate the Parameter, so I can also keep all the data if needed ? 

Thank you in advance !

[Syndicate_Admin]

Power BI:
Table.SelectRows(#"Change type", if ParmChooseCountry = null then each [Country]<>ParmChooseCountry else each [Country]=ParmChooseCountry)

[ChielFaber · Accepted solution]

I Think you can make this work. You can create something like this

First create a new parameter which only has the options true/false (TRUEFALSE_param)

false meta [IsParameterQuery = true, IsParameterQueryRequired = true, Type = type logical, List = {true, false}, DefaultValue = false]

As a second step you can create a blank query with an  if statement with the original paramater field (countries list)

if TRUEFALSE_param = true then Text.From(Countries_parameter) else "

[Columname] <> null and [Columname] <> "")

Then in the filter you could just use the Text.From function with this query as a source.

I used something similar in a native.sql query in Dataflows.