Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a report with mutiple tablix in it detailing Sales and purchase details. The requirement is to run the report for mutiple Items and the report output should be appended one after another.
The ITEM2 data should not be present in the same table as ITEM1. A new page/report should get generated for 2nd Item and so on.
Sample output shown below:
PAGE1: ITEM1
ITEM1 | ||||
Sales History | JAN | FEB | MAR | |
QTY | 100 | 200 | 300 | |
Purchase Order | ||||
ITEM1 | QTY | |||
PO1 | 110 | |||
PO2 | 200 | |||
PO3 | 50 |
PAGE2: ITEM2
ITEM2 | ||||
Sales History | JAN | FEB | MAR | |
QTY | 100 | 200 | 300 | |
Purchase Order | ||||
ITEM2 | QTY | |||
PO1 | 110 | |||
PO2 | 200 | |||
PO3 | 50 |
Hi , @useetharam
As far as I know, the paginated report in PBI can only pursue a more perfect matching effect of pixels when printing or exporting, but there is no function to automatically generate new pages/reports, for similar needs we can give advice is to go to Power Query to append query the original table in the data model to generate a full data table in the table or matrix placed in your paginated report:
Append queries - Power Query | Microsoft Learn
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |