cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DaveVox
Regular Visitor

Parameter Dropdown Not Returning Data with Multiple Selections

I have a problem with Paganted Reports from power BI where, if I create a Parameter with a multi-selection dropdown where the user selects multiple values from the list, the report returns no data.  I have attempted to select the "in" and the "=" operator in the Filter section of the Dataset Properties, and in the Query Designer, I have selected Equals and Contains from the available operator dropdown list.

 

Is there a way to correct this?

 

DropDown.jpg

1 ACCEPTED SOLUTION
DataZoe
Super User II
Super User II

@DaveVox This video Power BI Paginated Reports in a Day - 12: Working with Parameters - Part 2 - YouTube was my friend when I was working with parameters. When I was having issues it was becuase I created a bunch of stuff I didn't need to.

 

I got it to work using these steps.

1. Power BI Report Builder install

2. Go to Data Sources, Add Power BI Dataset Connection (authenticate, find phone, authenticate ha)

3. Go to Datasets, Add Dataset, choose the Data Source as the connection created above and click Query Designer to make it write DAX for us.

4. Add Customer to Dimension and lower box, also add other details.

5. Where I added Customer, make it bigger and check the Parameters box all the way on the right. Operator to Equal and Filter Expression to {All}. In the top bar above it make sure the last little icon is engaged (the Enable multi value paramaters).

2021-03-01_ReportBuilder1.png

6. Click OK, then OK again to get back to where we create our stuff.

7. A Parameter is automatically created for us! Just leave it be.

8. Insert a table with some details we want to see by Customer.

9. Click Run, and now it's showing us the Name with Blank() selected and nothing in the report.

2021-03-01_ReportBuilder2.png

10. You can now click the drop down to choose as many as you would like to see, then click "View Report" button on the right.

2021-03-01_ReportBuilder3.png

11. And the data comes back!

2021-03-01_ReportBuilder4.png

 

Hope this helps. What I learned was to let it do as much as possible then tweak as needed. I then went back to the CustomerName parameter it created and removed the option to "allow blank value" in "General", and chose "No default value" from the "Default Values" sections.

 

Respectfully,
DataZoe


See my reports and blog at https://www.datazoepowerbi.com/

View solution in original post

1 REPLY 1
DataZoe
Super User II
Super User II

@DaveVox This video Power BI Paginated Reports in a Day - 12: Working with Parameters - Part 2 - YouTube was my friend when I was working with parameters. When I was having issues it was becuase I created a bunch of stuff I didn't need to.

 

I got it to work using these steps.

1. Power BI Report Builder install

2. Go to Data Sources, Add Power BI Dataset Connection (authenticate, find phone, authenticate ha)

3. Go to Datasets, Add Dataset, choose the Data Source as the connection created above and click Query Designer to make it write DAX for us.

4. Add Customer to Dimension and lower box, also add other details.

5. Where I added Customer, make it bigger and check the Parameters box all the way on the right. Operator to Equal and Filter Expression to {All}. In the top bar above it make sure the last little icon is engaged (the Enable multi value paramaters).

2021-03-01_ReportBuilder1.png

6. Click OK, then OK again to get back to where we create our stuff.

7. A Parameter is automatically created for us! Just leave it be.

8. Insert a table with some details we want to see by Customer.

9. Click Run, and now it's showing us the Name with Blank() selected and nothing in the report.

2021-03-01_ReportBuilder2.png

10. You can now click the drop down to choose as many as you would like to see, then click "View Report" button on the right.

2021-03-01_ReportBuilder3.png

11. And the data comes back!

2021-03-01_ReportBuilder4.png

 

Hope this helps. What I learned was to let it do as much as possible then tweak as needed. I then went back to the CustomerName parameter it created and removed the option to "allow blank value" in "General", and chose "No default value" from the "Default Values" sections.

 

Respectfully,
DataZoe


See my reports and blog at https://www.datazoepowerbi.com/

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors