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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
murali5431
Helper III
Helper III

paginated report parameter entry

Hi,

 

I am very new to paginated reports. I was looking through training material for parameters, but I could not find any information on how to define a parameter for which I could enter parameter values(s) manually (like pop-up box), which would then provide me a report for the entered values(s). What I found was only building a dropdown.

 

For example, I have 1000+ invoices and I need to define a parameter which would request entry of  invoices number(s), and subsequently provide a report for the invoices entered.

 

Please assist.

 

Thanks,

Muralidhar  

1 ACCEPTED SOLUTION
AbhiSSRS
Solution Sage
Solution Sage

Hello!
 Please add a parameter as below and select appropriate option. If you want your parameter to be multi valued you may select Multi, also if you want it pre -populated with all Invoices then go to  Available values and populate the values from a dataset. Please let me know if you face any issues .

AbhiSSRS_0-1617199124101.png

AbhiSSRS_1-1617199231498.png

 

 

View solution in original post

4 REPLIES 4
AbhiSSRS
Solution Sage
Solution Sage

Hello!
 Please add a parameter as below and select appropriate option. If you want your parameter to be multi valued you may select Multi, also if you want it pre -populated with all Invoices then go to  Available values and populate the values from a dataset. Please let me know if you face any issues .

AbhiSSRS_0-1617199124101.png

AbhiSSRS_1-1617199231498.png

 

 

Thank you @AbhiSSRS 

 

I did find the solution for it.

pabeader
Post Patron
Post Patron

You can use a query to populate the dropdown.  Look for that in Google and I bet you will find something that will work for you.

 

Thank you @pabeader 

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

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.