Comma-separated expression

[mrslyfox911]

Hello,

I need expression for my PowerBI Paginated report.
Dataset name: RequestedInstances

Field 1: Instance

Field 2: Count_Instances

I need a comma-separated list of all values 'Instance'

For the current expression, I have an error:

The 'Value' expression for the text box 'Textbox22' refers directly to the field 'Instance' without specifying a dataset aggregate. When the report contains multiple datasets, field references outside of a data region must be contained within aggregate functions which specify a dataset scope.

Expression: =Join(Fields!Instance.Value, ", ")

[M_nwadibia]

Can you try this. What this does is to add comma separator to 2 or more digit number but keeps single digits as they are

IIf(Len(CStr(Fields!Column_Name.Value))>1, Join(Split(CStr(Fields!Column_Name.Value),""),","), CStr(Fields!Column_Name.Value))

[mrslyfox911]

report header allows only static data, for that reason workaround was applied to the dataset