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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
WilliamA
Frequent Visitor

Table drill down only applies to one Column

Hi guys,

 

I have 2 tables - a Summary and a Detail with the related fields sharing a many to many relationship. The report has 2 table visuals one for the summary and the other the details. When you select a row from the summary table it should filter the detail table on all the related fields. However, it appears to only be filtering on the active relationship. 

 

When I attempt to make all the relationships active, I get an error due to a set of indirect relationships.

 

My model looks like the following - 

WilliamA_0-1695600394871.png


The expected outcome is when a row is selected from the Credit_Note_Duplicates table, it should filter the CN_Duplicate_CNs_Fact table for all the related fields.  Both tables share relationships with a date table as well as a hierarchy table for locations.


Is it possible to filter on more than one column? 

1 REPLY 1
amitchandak
Super User
Super User

@WilliamA , the other visual or the drill through visual should have the measure with userelationship to filter

 

example

Power BI Drill Through when Userelationship is used: https://youtu.be/1BM_WGATrQA

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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