Forum Discussion
Paginated Reports DAX for multi-select parameter
I am integrating a Paginated Report into my Power BI app. I have successfully linked my slicer values with the report paramters.
I have no problem with a single selection. However, I know I have to do something more to get a multiple select filter to work with the DAX query.
First screenshot shows my desired result. a report which include three parameter values. (currently only the first parameter is in effect)
The Parameter Value text is created as follows:
DAX Parameter substitution:
What I need is a way to expand the parameter to include all values, similar to the join used for the text box. The parameter works when I trim it to "Parameters!Fleet_Name.Value(0)".
I need to figure out where and how to deal with a multi-valued parameter.
In T-SQL I would use an "in('a','b','c'). I probably need to find a DAX equivalent
4 Replies
Adding context, basically I need to get from Exhibit A to Exhibit B. I've tried joins, string manipulation, etc. No luck.
What I get from Power BI:
What I need to get me here in Report Builder:
I was hoping for a personal DUUHHHH, in that I was missing something totally obvious or making a simple syntax error. Sadly not, this is apparently an issue where Paginated for Power BI fails due to complexities with DAX. I have verified via SSRS that multiple parameters work exactly as advertised. I hope PBI catches up.
I will accept your pointer to RSCUSTOMFILTER as the closest possible solution, thanks.
Hi tommy_g , I'm having the same issue, have you found a solution which lets you use multi value parameters?
