Forum Discussion

JitK's avatar
JitK
Frequent Visitor
6 years ago
Solved

Power BI Report Builder- Report having multiple sheets

Hi All,   Did anyone developed a report using Power BI Report Buider having multiple sheets?. Like in Excel , One Excel file can have multiple sheets and each sheet connect to seperate Oracle Sql qu...
Reports
  • saglamtimur's avatar
    saglamtimur
    6 years ago

    Ok, say you have a data like

    CompanyKeyQtyKg
    A1
    A2
    B2
    B3
    C2

    and would like to show sum(QtyKg) for each Company in separate pages/sheets

    First, add a matrix and design it how you like it.

     

     

     

     

     

     

     

     

     

     

     

     

    right click over "CompanyKey" group under "Rows groups" and select "Group properties" and then "Page breaks" tab and click "Between each instance of a group"

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    By doing this, your report shows your report as an each group on separate pages. And if you export to excel, on separate sheets. 

    But, for excel there is still a problem. sheet names are default to Sheet1, Sheet2.... and son on. To rename those sheets; click on to select "CompanyKey" group under "Rows groups" and then at the right you will see "Properties" pane. Drill to "Group -> Group -> Page Name" property and open expression combo box, then set what ever you want for the expression which will be shown as "Sheet names" in excel.

JitK's avatar
JitK
Frequent Visitor
6 years ago

Hi Saglamtimur

 

 Thank you. I checked for the subreport option in power bi report builder and it is disabled for me always. I am using version 15.0.1517.0. Please let me know in which version this option is enabled and appreciate if you provide me step by step guide for creation of subreport which works same way like one report contain multiple sheets.

 

Appreciate your help.

 

Thanks

JitK