Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Drill through in power bi


I am using drill thorough option in power bi.

There are two different tables in power bi and i need to create one report such that when i click on one field in 1st report then details of that will be shown on second table report using drill through option 

There is only 1 common column between those two tables


So if any sol for this will be appreciated. 

Community Support
Community Support

Hi @Usinghal ,



What I did was creating a bridge table for the mutual column, made a relationship with the other two tables and used it in the two tables.

Please refer to the following article about a bridge table to see if it helps you.




Best Regards

Community Support Team _ polly


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

Super User
Super User

Didn't quite understand that issue, if you are looking for a basic drill through flow then there are many videos on youtube,

Did I answer your question? Mark my post as a solution! and hit thumbs up

Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group


I am asking that can i drill through two tables in power bi having only one common column in it.

And how i can do it

Helpful resources

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors