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.
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.