Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!View all the Fabric Data Days sessions on demand. View schedule
I got 1 parameter which its come from sql query. User might click more than 2 workorder as below:

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

I want it show all user select from the checkbox and separate by comma.
As example: 2022008311, 2022011967
How can I make it?
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.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!