Selected row in 1 table to shows multiple related rows in another table

[dashuster]

I have Table 1 with a field for each row that has a single field wich contains 0, 1, or many ID's of related rows in another table named "Realated Table 2".

Table 1	Related Table 2
a	1,3,4,6,7
b	2,4
c	1,3,4
d	6
e	3
f	4,5

... and I have Table 2

Table 2	Related Table 1
1	a,c
2	b
3	a,c,e
4	a,b,c
5	f
6	d
7

I have expanded Table 1 using delimter in "Related Table 2" field and have:

Table 1	Related Table 2	Related Table 2.1	Related Table 2.2	Related Table 2.3	Related Table 2.4	Related Table 2.5
a	1,3,4,6,7	1	3	4	6	7
b	2,4	2	4
c	1,3,4	1	3	4
d	6	6
e	3	3
f	4,5	4	5

What I want to do is select Table 1 Row[A] and display related rows 1,3,4,6,7 in the Table visual on the same page of the report.  

... or "drillthrough" to another page with the rows, 1,3,4,6,7 only.

I am new to PBI and my "taste" is a bit ahead of my "skill" - lol

[amitchandak]

@dashuster , In power query, split the column by delimiters into the rows in both tables and use that join the table and plot on visual

https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/

[dashuster]

Already did that.  Its the next step of joining the two