Why does multi-value parameter only return maximum value selected

[ldwf]

I have a Paginated Report that connects to a dataset in the cloud.  It has several parameters, and one of the parameters works fine if it is designed to select one value.  I change the parameter properties to allow multi-selecting.  When I run the report I am able to select multiple values, but the report only brings back the maximum value selected in the dropdown.   The list is alphabetical, so it returns the highest value selected in alphabetical order.  I did add a filter so that it searches where the value is 'in' the parameter (vs '='), but that doesn't make a difference.  Any ideas how to resolve this? 

[Anonymous · Accepted solution]

Hi @ldwf ,

Please review the content in the following blog and check if there is something missing when you create and configure the multi-value parameter...

Add a multi-value parameter to a paginated report - Microsoft Report Builder & Power BI Report Build...

SSRS Using Multi-value Parameters

Select the option "Allow multiple values"

=Parameters!parametername.Value

Remove the "(0)" from the expression of parameter

Best Regards