Forum Discussion
Dynamic filtering of rows using a parameter
Thanks for the explanation. As far as I know, it is not possible to select multiple parameter values from the list.
This is also confirmed in this topic.Aren't you looking for a slicer visual with the option to select all items?
In that case you don't need a separate statelist, but you can just use the "State" column from your data.
You may try and adjust Custom1 step as follows:
Custom1 = if State is null then dbo_tblClinics else #"Removed Columns"
It is strange that you have a parameter that may have a list as a value: this is not something that can be defined via the User Interface.
This code:
{"State1","State2"} meta [IsParameterQuery=true, Type="Any", IsParameterQueryRequired=true]
Looks like this in the User Interface:
How did you define parameter State?
Here is my "State" parameter (screenshot below). The 2nd screenshot refers to the "StateList" which is derived from a database query.
Essentially the user should be able to choose one or more states or not choose a state from the state parameter list. This will drive (cascading dropdown) the database query (clinics applicable for given state) for my 2nd parameter which will eventually drive my final query. If the user does not choose any parameter values for state and/or clinic then there is no filter applied to my final query and all rows are returned. I hope this helps explain my problem situation. Thanks again for your help.
Thanks for the explanation. As far as I know, it is not possible to select multiple parameter values from the list.
This is also confirmed in this topic.Aren't you looking for a slicer visual with the option to select all items?
In that case you don't need a separate statelist, but you can just use the "State" column from your data.