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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Sb00cheh
Regular Visitor

Drillthrough by a removed filter on a Specific Visual

Hi,

I've created a drillthrough for an employee details page. The drillthrough is using Name to provide the employee details which display typical fields (name, title, management level, business unit, department, etc.) However, I want to create a table within that drillthrough page that lists other employees that share the same title. Is this possible, as that table filters to name so it only results into the employees name and not their colleagues? I can bypass by doing another another drillthrough from the employee page, that yields the list of folks with the same titles, however, i'd really like it displayed on the employee page itself. Is there a way to bypass or write a measure to get it all displayed on a single drillthrough page?

For instance, is there a way to link a table from another page, or a DAX formula for a measure that can display all names that share the EEs title?

1 ACCEPTED SOLUTION
v-huijiey-msft
Community Support
Community Support

Hi @Sb00cheh ,

 

Thanks for the reply from ToddChitt . The method ToddChitt provided was helpful, I have another method.

 

Make a copy of the original table, the reason for this is that if you use the original table on the drill through target page, the filtering effect will filter out the data, so you need to use a new table with the same data on the target page.

 

Create a measure that returns 1 when the title obtained after page 1 drill through is equal to the title of the new table.

MEASURE =
VAR _curTitle =
    SELECTEDVALUE ( 'EmployeeData'[Title] )
RETURN
    IF ( MAX ( 'EmployeeData (2)'[Title] ) = _curTitle, 1 )

 

When clicking on Alice's name drill through in page1, the visual effect of page2 is shown below:

vhuijieymsft_0-1737017996629.png

vhuijieymsft_1-1737017996631.png

 

The pbix file is attached.

 

If you have any other questions please feel free to contact me.

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

View solution in original post

3 REPLIES 3
v-huijiey-msft
Community Support
Community Support

Hi @Sb00cheh ,

 

Thanks for the reply from ToddChitt . The method ToddChitt provided was helpful, I have another method.

 

Make a copy of the original table, the reason for this is that if you use the original table on the drill through target page, the filtering effect will filter out the data, so you need to use a new table with the same data on the target page.

 

Create a measure that returns 1 when the title obtained after page 1 drill through is equal to the title of the new table.

MEASURE =
VAR _curTitle =
    SELECTEDVALUE ( 'EmployeeData'[Title] )
RETURN
    IF ( MAX ( 'EmployeeData (2)'[Title] ) = _curTitle, 1 )

 

When clicking on Alice's name drill through in page1, the visual effect of page2 is shown below:

vhuijieymsft_0-1737017996629.png

vhuijieymsft_1-1737017996631.png

 

The pbix file is attached.

 

If you have any other questions please feel free to contact me.

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

Thanks! Worked like a charm!

ToddChitt
Super User
Super User

Not sure if this will work, but try creating a COPY of the employees table with a simple DAX formula:

Employees2 = Employees

Relate Emplyees2 to Employees on the Title field of each table. Make it a Many-to-Many relationship.

Now when you filter Employees by [Name], Power BI can traverse the relationship to Employees2 by matching anyone with the same Title. On your drillthrough page, add rows from Employee2. That should be the people that have the same Title as the filtered (drillthrough) employee.

Hope that helps.




Did I answer your question? If so, mark my post as a solution. Also consider helping someone else in the forums!

Proud to be a Super User!





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!

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!

Feb2025 NL Carousel

Fabric Community Update - February 2025

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