Forum Discussion

scabral's avatar
scabral
Icon for Helper IV rankHelper IV
2 years ago

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

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 c...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
scabral
Icon for Helper IV rankHelper IV
2 years ago

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