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

View all the Fabric Data Days sessions on demand. View schedule

Reply
space83
Helper IV
Helper IV

power bi report builder show all parameters

I got 1 parameter which its come from sql query. User might click more than 2 workorder as below:

 

workorder-dropdown.jpg

 

But when display in report, it only able show only 1 workorder.  the setting expression is as below:

powerbi-dax.jpg

 

I want it show all user select from the checkbox and separate by comma.

As example: 2022008311, 2022011967

 

How can I make it?

 

 

 

1 REPLY 1
msampson_inclsv
New Member

I had this same question and I solved it by using the Join function: Join(Parameters!MultivalueParameter.Value,",")`

 

More concretely, a user could check multiple years (e.g. 2022, 2023) and by using this function, 

Join(Parameters!YearParam.Value,","), the report would show: 2022,2023. 

 

Hope this helps anyone else coming across this question.

Disclaimer: I know verrrry little about PowerBI Report Builder.

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors