Reply
slewis
Helper I
Helper I

Different Drillthrough Tables

I have a need: I have a summerized chart built from table A . I want to drill through to another page that takes it data from table B. Table A and B have simmilar fields (i.e. month and year). 

 

I want to be able to drill trough to that other page using the filter criteria from chart A onto table B. Is this possible and if so how?

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

hi, @slewis 

Try this way:

Add a bridge table for simmilar fields (i.e. month and year)

Then create the relationship between A and B by bridge table.

Now use month and year from bridge table in the visuals and set drill through by it.

 

Best Regards,
Lin

 

Community Support Team _ Lin
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

3 REPLIES 3
v-lili6-msft
Community Support
Community Support

hi, @slewis 

Try this way:

Add a bridge table for simmilar fields (i.e. month and year)

Then create the relationship between A and B by bridge table.

Now use month and year from bridge table in the visuals and set drill through by it.

 

Best Regards,
Lin

 

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

I used the custom Date table as the link. It works.

A bridge table like a custom date table? If I use the same bridge on all my tables then would that mean that drill through will appear with an option for every report tab?

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

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

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)