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

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
Anonymous
Not applicable

Page Break on power bi report builder based on parameter selection

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

2 REPLIES 2
Anonymous
Not applicable

Hi, Thanks for your reply.

This is not clear to me, can you please explain me in detail.

 

Thank you so much in advance

Sahir_Maharaj
Super User
Super User

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]
)

Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Sahir Maharaj
Data Scientist | Data Engineer | Data Analyst | AI Engineer
P.S. Want me to build your Power BI solution? (Yes, its FREE!)
➤ Lets connect on LinkedIn: Join my network of 15K+ professionals
➤ Join my free newsletter: Data Driven: From 0 to 100
➤ Website: https://sahirmaharaj.com
➤ About: https://sahirmaharaj.com/about.html
➤ Email: sahir@sahirmaharaj.com
➤ Want me to build your Power BI solution? Lets chat about how I can assist!
➤ Join my Medium community of 30K readers! Sharing my knowledge about data science and artificial intelligence
➤ Explore my latest project (350K+ views): Wordlit.net
➤ 100+ FREE Power BI Themes: Download Now
LinkedIn Top Voice in Artificial Intelligence, Data Science and Machine Learning

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

February Power BI Update Carousel

Power BI Monthly Update - February 2026

Check out the February 2026 Power BI update to learn about new features.

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.