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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
src_admin_01
New Member

Power Bi Report Builder Optioonal Multi-Select Parameters

I tried 3 or 4 different ways of doing this but haven't figured this out.  I'm using power bi report builder desktop to build a paginated report with dataverse as the datasource.  I'm trying to make my multiselect parameters optional.  I tried using Power Bi Data service as my source with dax and have also tried to query dataverse directly.  What am I missing?

 

Im able to get all data back with the default value "ALL in the parameter...I can get one parameter to work as well.  The problem is I can't get the values to pass in if I select more than one value.  Below is my query with parameters in the where clause.

 

src_admin_01_0-1685620678849.png

 

I tried to add a join to the parameter mapping and it still not allowing more than one value. I've tried =join(Parameter!dept.Label, "|") and =join(Parameter!dept.Value "|").  

 

Thanks in advance

 

0 REPLIES 0

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.