How to script a parameter query to return "SelectAll" when slicer "Select All" is unselected?

[Anonymous]

By default a slicer having the "Select All" (and all other values) unselected act in same way on a table visual object as when "Select All" is selected.

I have used the Dynamic M query parameters example (https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters) and wonder how to modify the Dynamic Query script to act in the same way on a slicer with "Select All" (and all other values) unselected?

My script returns no rows from the Dynamic Query in the table visual when slicer has "Select All" (and all other values) unselected. How can I modify the script to interpret this slicer state as a "return all rows" situation instead of "return no rows"? 

[artemus]

My guess is that __SelectAll__ is getting passed as a single item instead of a list. Try changing line 10 to ColorParameter = "__SelectAll__"

PS: You should redact your SQL server name.

[Anonymous · Accepted solution]

Thanks for the response! But I am not sure I understand your suggestion. 

Should the SelectAllProducts Else-condition <else false> be replaced with <else ColorParameter = "__SelectAll__"> ?

The modification does not seem to make any different outcome. The slicer with all values unselected does still produce a query that returns an empty table visual.

After some testing I used this coding method to check if the slicer is unselected (the blankProdType expression). I also test the AllProductsSelected expression (valgtAlleProdTyper) and finally test the combination of selections (Text.Combine) to formulate the dynamic WHERE-condition. It works fine but it is maybe not the best way to solve the issue.