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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
somechat1
Regular Visitor

Text box is not populating with parameter values

Hi, 

 

I have two parameters called "Company Id" & 'Terminal Id". User will select the id's from these two parameters and the selected id's need to be shown as a list separated by commas in a text box. 

 

I have added the below formulas in the text boxes.

 

Company ID =JOIN(Parameters!VUFSDAILYPROFITRPTCOMPANYID.Value," , ")

Terminal ID =JOIN(Parameters!VUFSDAILYPROFITRPTORIGTERMINALID.Value," , ")

 

However, it is showing the values like this below in the text boxes (table name, schema name) instead of the ID when the report runs.

 

somechat1_0-1686053138801.png

Any help on this would be greatly appreciated.

 

Thanks in advance !

1 REPLY 1
lbendlin
Super User
Super User

What language is that? In DAX you would use CONCATENATEX.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.