Forum Discussion
Paginated report with multi valued parameter not working
Hi v-lid-msft ,
I have set the parameter to be multi valued and also in the dataset I have set the default to select all the values as showed in the below video.
https://www.youtube.com/watch?v=KYfhclGrI48&t=922s
Regards,
Prime
Community SupportHi Anonymous ,
How about the result if you repeat the parameter name for each value in a URL?
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-lid-msft ,
I have managed to send the selected parameters using the concatenatex function, i.e. to split using a comma.
But in the Paginated report when I try to run the report by passing multiple values it give me blank records and when I use one value then it works fine.
I was about to create a post asking if it's possible to filter a dataset or tablix with multiple values from a multi-value parameter, as I've tried every trick in the book that I can find for SSRS, but nothing works. I'm thinking this is a bug. A costly bug at that in the case of this project!
Hi Anonymous ,
Looks like that is the case, I have created a incident with the microsoft support team, and he advised me to go through the following websites
- Use of DAX PATHCONTAINS: https://prologika.com/ssrs-multivalue-parameters-in-dax/
- Another Example: https://blog.crossjoin.co.uk/2018/05/16/a-new-approach-to-handling-ssrs-multi-valued-parameters-in-dax-queries/
- About the @RSCustomerDaxFiler (available only inside the PBI Report Builder Query Designer): https://blog.crossjoin.co.uk/2019/11/03/power-bi-report-builder-and-rscustomdaxfilter/
But the solution in these links work with SSAS data source and not PowerBI data source. The guy himself tried with a remote dektop session and he couldn't figure it out.
I am waiting for him to get back to me, Once I hear anything will give you an update.