Forum Discussion
Add multiple tables dynamically in a Paginated report
Hi,
I have this PBI paginated report build with PBI Report Builder which takes Region name as a parameter and need to display some data in a table for each branch in that region.
Say region R1 has 3 branches B1, B2, B3 the report should create 3 tables for each branch.
Respectively if R2 has 5 branches it should display 5 tables.
My data source is something like this:
My data source is something like this
I have tried a matrix with blank lines in between but it doesn't look nice. (It'd be OK if I can get the header row repeating in each part)
Is there a way I can handle this in PBI? Or any work around?
Thanks
Thanks for the suggestion Anonymous anyway I was able to get this done by adding another static row on top of the blank row in my above SS, finally!
4 Replies
Hi Kapz ,
It seems to be by default. Maybe you could submit for it.
https://ideas.powerbi.com/ideas/
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the suggestion Anonymous anyway I was able to get this done by adding another static row on top of the blank row in my above SS, finally!
Designer view
Can you pls post details on how you achieved this? Thank you in advance..
