Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreNext 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
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]
)
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Experience the highlights from FabCon & SQLCon, available live and on-demand starting April 14th.
| User | Count |
|---|---|
| 47 | |
| 44 | |
| 40 | |
| 20 | |
| 15 |
| User | Count |
|---|---|
| 70 | |
| 67 | |
| 32 | |
| 27 | |
| 25 |