I’m trying to add a multiple value parameter to a paginated Power BI report in Power BI report builder. When selecting multiple values for the parameter, the report returns only the first row of data for the selected parameter.

My main query looks like this: enter image description here The query was made using the Query Designer feature and clicking “evaluate” to load the data results.

My parameter, “Client” has “Allow Multiple Values” checked and gets its values from a separate query with a list of all the clients. This query was built the same way, only pulling in the Client field.

In my main query, I added the parameter to the filters section of the dataset like this: enter image description here

The value is set =Parameters!Client.Value(0)

When I run this report, I’m returned only the first client in the selected list from the parameter. I have tried selecting all clients or just a couple. When I remove the parameter, I can see all rows for all clients. My visual is a matrix with grouping on the client.

I would like the parameter to return rows for all clients selected when I run the report.