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!Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
I have a requirement like I need to create a paginated report based on the parameter selection it sould print all the selected order no's on one page based on parameter selected oreder number. here is some exampl assume that I have a order No column and country column, so I have creted a parameter based on order no if user select order no-1 from the parameter below the date should be printed on the page.
Order No Country
1 Japan
1 China
Here is some dummy data based on each selection it should be print below criteria so where we can configuare this functionality.
Order No- Country
1 Japan
1 China
3 India
4 Srilanka
5 Canada
5 America
Parameter filter - Based on Order No
1st Filter order no-1 on page-1
Order No Country
1 Japan
1 China
2nd filter order no-3 on page-2
Order No Country
3 India
3rd filter order no-4 on page-3
Order No Country
4 Srilanka
4th filter order no-5 on page-4
Order No Country
5 Canada
5 America
Can someone can please help me on this. I really appreciate it. Thanks in well advance
Hi, Thanks for your reply.
This is not clear to me, can you please explain me in detail.
Thank you so much in advance
Hello @Anonymous,
Can you please try this approach:
Filtered Data =
SUMMARIZE(
FILTER(
YourTable,
YourTable[Order No] IN VALUES(ParameterTable[Order No])
),
YourTable[Order No],
YourTable[Country]
)
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the February 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 52 | |
| 51 | |
| 35 | |
| 15 | |
| 14 |
| User | Count |
|---|---|
| 92 | |
| 75 | |
| 41 | |
| 26 | |
| 25 |