cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Usinghal
Helper I
Helper I

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-polly-msft
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.

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

@Usinghal 
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

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