Forum Discussion
Multiple side by side reports for the respective multi-parameter selection in BI Report Builder.
This is the rough format of our report. We are using BI Report Builder or paginated.
A | B | C |
Right now: Project 1 details Project 2 details ….. | P1 P2 | P1 P2 |
D | E | F |
| - |
|
G | H | |
|
|
I |
|
J |
|
K |
Let’s say my parameters are 1-100 (Project ID’s) . Right now, if I select multiple parameters, I get the data for all the parameters in a single report. I want 3 individual reports to be generated with the same format for my multiple parameter selection. If I select 1,10, and 20 as my parameters in the report builder, I must get 3 separate or individual reports with the same format for 1, 10 and 20 respectively. This should work for any number of parameter selection where I must get separate reports of the same format for all parameter selection. Is it possible to do such thing in the BI Report Builder? Is there any other way to achieve this if it's not possible in BI Report Builder? Any help is much appreciated. Thank you.
2 Replies
Hi Anonymous ,
Not sure if i understand you correctly, but i did some research on the offical documents of Power BI Report Builder and i'm afraid this can't be done currently. I'd like to suggest you to submit your idea.
https://ideas.powerbi.com/forums/265200-power-bi-ideas.
And here's some documents for your reference.
https://docs.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-pagination.
https://docs.microsoft.com/en-us/power-bi/paginated-reports/report-builder-url-parameters.
https://docs.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-pagination.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello Anonymous
Thank you for your reply. Whenever we produce a report in the report builder, we just select parameters from the drop-down menu and results are all populated in one page or one report. However, I just want the same table to be produced multiple times for every parameter I selected. When I select A, B, and C, I want three tables to be produced for A, B, and C instead of one page with the results of all three parameters. I will export that in to a word file in the end which anyway looks exactly like my results. I suppose it's similar to the subreport feature in SSRS. I am not sure it's the same and I just wanna know whether this can somehow be achieved using the paginated reports.
Thank you.
SHT.