Skip to main content
cancel
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.

Reply
Anonymous
Not applicable

Drill through in power bi

Hi

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. 

3 REPLIES 3
v-rongtiep-msft
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.

https://docs.microsoft.com/en-us/power-bi/guidance/relationships-many-to-many

 

 

 

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.

Fowmy
Super User
Super User

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

https://www.youtube.com/watch?v=WdBeJ8j98ME
https://www.youtube.com/watch?v=2x9lLHDbtDk

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

Anonymous
Not applicable

@Fowmy 

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

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.