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

The FabCon + SQLCon recap series starts April 14th at 8am Pacific. If you’re tracking where AI is going inside Fabric, this first session is a can't miss. Register now

Reply
Ghoom
Frequent Visitor

Button to Drill Through to Page filtered by Unrelated Slicer

I have two primary tables, one which describes sample information, and a related table with results based on the field ID.

 

tbl_Info

IDDetail 1Detail ... x
1ax
2by
3cz
4ay
5di

 

tbl_Results

IDFeatureResult
1a100
1b200
1c250
2c500
2e40
3h600
3a850
4g100
5g200

 

Info ID is related 1:* on the Results ID

 

Here's where the trouble comes in:
I have a table of "Related Samples" which I want to compare the results of the two samples. Esentially pointing ID to ID. 

RelatedSamples

IDRelated ID
3
12
45

 

I have a report tab which uses measures to compare the results from each test based on two slicers slicers:

RelatedSamples[ID]

RelatedSamples[RelatedID]

 

I'd like to create a button to drill through to all the details of either the slicer selections on another report tab.

 

I cannot create a relationship between RelatedSamples and tbl_Info since both [ID] & [RelatedID] fields are the same relationship. Therefore the slicers on the comparison tab are unrelated to tbl_Info, and a button cannot be used either. Suggestions?

2 REPLIES 2
amitchandak
Super User
Super User

@Ghoom , You drill using tbale 1 and table 2

 

and then use a measure to capture values

 

example

countrows(filter(RelatedSamples , RelatedSamples [ID] in Values(tbl_Info[Values]))

 

 

or vice versa. Make sure the drill page, you add the columns on which you want to drill

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

I appreciate the response! I was hoping I wouldn't have to go this route as I currently have created the "details" page controlled by a tbl_Info[ID] filter.

It seems the only way to do this is re-creating each visual on the "details" page with a new measure?

Helpful resources

Announcements
New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

March Power BI Update Carousel

Power BI Community Update - March 2026

Check out the March 2026 Power BI update to learn about new features.