Forum Discussion
How to script a parameter query to return "SelectAll" when slicer "Select All" is unselected?
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.
Microsoft EmployeeMy 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.
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.