Drop down for the subreport

[Aartibhilare]

Hi team,

I need to include 10 subreports within a single report. Is there a way to implement a dropdown to select between them?

If so, how can we achieve this?

From what I know, we can embed all the reports and set visibility conditions. However, these reports need to work with the access restrictions defined in our SQL database and queries. What would be the most straightforward approach to manage this?

[rohit1991 · Accepted solution]

Hi @Aartibhilare ,
Dropdown for Subreports in Power BI Report Server

Solution: Use a Parameter to Control Visibility

1. Create a Parameter (ReportSelector) → List subreport names.
2. Insert 10 Subreports → Place all in the main report.
3. Set Visibility for Each Subreport
   • Use: =IIF(Parameters!ReportSelector.Value = "Report1", False, True)
   • Repeat for each subreport.

4. Access Control:

   • Filter available reports based on user roles in SQL.

"The goal is to turn data into information, and information into insight." – Carly Fiorina

Need Power BI help? Connect on LinkedIn.

[Aartibhilare]

@rohit1991 

Thanks Rohit