Forum Discussion

useetharam's avatar
useetharam
New Member
3 years ago

Paginated Report: Append Reports based on multi-valued parameter.

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 JANFEBMAR
QTY 100200300
     
Purchase Order    
ITEM1  QTY 
 PO1 110 
 PO2 200 
 PO3 50 

 

PAGE2: ITEM2

 

ITEM2    
Sales History JANFEBMAR
QTY 100200300
     
Purchase Order    
ITEM2  QTY 
 PO1 110 
 PO2 200 
 PO3 50 
Need Help

1 Reply

  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    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