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
joshua1990
Post Prodigy
Post Prodigy

Drill Through from Manager to Employee

Hi community!

I have an App with multiple reports.

One of them is focused the Manager and one of them is based on the Employess. It is not possible to merge both reports.

In the data model there is a table that shows the relationship between manager and employee.

Is there any way / workaround to do a drill through from the manager report to the employee report?

 

1 ACCEPTED SOLUTION

Hi @joshua1990 ,

 

Here I create a sample to have a test.

Manager Report:

vrzhoumsft_0-1682390279332.png

Employee Report:

vrzhoumsft_1-1682390375173.png

Although the schemas in each report don't have to be the same, the fields you want to pass must exist in both data models. The names of the fields, and the names of the tables they belong to, must be identical. The strings must match, and are case-sensitive.

You can see there is a Relationship table in both tables. It is the same and it looks like as below.

vrzhoumsft_2-1682390448354.png

Then set up and configure the cross-report drill through in both reports. Here I add [Manager] column from Relationship table into filter field in Employee report. Make sure you use [Manager] column from Relationship in your visual in Manager table as well.

vrzhoumsft_3-1682390549132.png

You can follow this offical blogs to learn more details. Publish reports to Power BI Service and check the result.

vrzhoumsft_4-1682390657295.png

vrzhoumsft_5-1682390684897.png

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
joshua1990
Post Prodigy
Post Prodigy

No ideas?

Hi @joshua1990 ,

 

Here I create a sample to have a test.

Manager Report:

vrzhoumsft_0-1682390279332.png

Employee Report:

vrzhoumsft_1-1682390375173.png

Although the schemas in each report don't have to be the same, the fields you want to pass must exist in both data models. The names of the fields, and the names of the tables they belong to, must be identical. The strings must match, and are case-sensitive.

You can see there is a Relationship table in both tables. It is the same and it looks like as below.

vrzhoumsft_2-1682390448354.png

Then set up and configure the cross-report drill through in both reports. Here I add [Manager] column from Relationship table into filter field in Employee report. Make sure you use [Manager] column from Relationship in your visual in Manager table as well.

vrzhoumsft_3-1682390549132.png

You can follow this offical blogs to learn more details. Publish reports to Power BI Service and check the result.

vrzhoumsft_4-1682390657295.png

vrzhoumsft_5-1682390684897.png

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

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.