Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Regular 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 - 


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? 

Super User
Super User

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



Power BI Drill Through when Userelationship is used:

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors