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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Not applicable

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 @Anonymous ,



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

Not applicable


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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.


Power BI Monthly Update - May 2024

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


Fabric certifications survey

Certification feedback opportunity for the community.