Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Aartibhilare
Helper III
Helper III

Drop down for the subreport

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?

1 ACCEPTED SOLUTION
rohit1991
Super User
Super User

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.

View solution in original post

2 REPLIES 2
rohit1991
Super User
Super User

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.

@rohit1991 

 

Thanks Rohit

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.