Paginated Report - Adding Double Quotes around a comma in a parameter string

[scabral]

Hi,

I created a paginated report and used the paginated report visual to embed in a power bi report.  I am passing a parameter to the paginated report from Power BI using CONCATENATX to build a comma separated list of values that is then used in the paginated report DAX using an IN{} statement.

Howerver the string comes through like this:

"Value1,Value2"

i want it to come through like this in order to work correctly in the IN statement:

"Value1","Value2"

I tried to use an expression against the parameter in the paginated reprot to try to add the double quotes around the field, but I can't quite seem to get it exactly like I want.  Right now I am using this expression:

="" & Replace(Parameters!paraDivision.Value, ",", """,""") & ""

but it's coming throught like this with 2 sets of double quotes around the comma, but I only need 1 set:

"Value1"",""Value2"

I've tried multiple ways to get around it, but nothing seems to work?  Any ideas on how to get this working?

thanks

Scott

[v-jianpeng-msft]

Hi, @scabral 

Maybe you can try the following expressions:

="""" & Replace(Parameters!paraDivision.Value, ",", """,""") & """"

Expressions start and end with a set of double quotation marks to ensure that the entire string is enclosed correctly. The function then inserts a set of quotation marks around each comma.

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[scabral]

hi,

with that code, it's coming across like this:

"""Value1"",""Value2"""

so now it's adding an extra set of quotes in the beginning and end of the string and still has the 2 sets of double quotes around the parameter.  I need it like this:

"Value1","Value2"

Power BI is sending it over like this using CONCATENATEX:

"Value1,Value2"

I've spend hours trying to get this to work but can't get it exactly how i want it