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

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. 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
New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

FabCon and SQLCon Highlights Carousel

FabCon &SQLCon Highlights

Experience the highlights from FabCon & SQLCon, available live and on-demand starting April 14th.

March Power BI Update Carousel

Power BI Community Update - March 2026

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