Drill through in power bi

[Anonymous]

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. 

[Anonymous]

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]

@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

[Anonymous]

@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