Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
mrslyfox911
Advocate III
Advocate III

Comma-separated expression

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, ", ")

 

2 REPLIES 2
M_nwadibia
Resolver III
Resolver III

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
Advocate III
Advocate III

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

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.