Table visualization

[santhoshrama]

Hello everyone,

Greetings!!!

I'm looking support for the below topic

 - I am having below two tables with one to many relationship activated. I like to have a table visualization that shuould have combination of two

 input :

Table1

Code

A

B

C

D

Table2
Code	Description
A	Name1
B	Name2
C	Name3
	Name4
	Name5
	Name6

Result I am getting in table visualization
Code	Description
A	Name1
B	Name2
C	Name3
D
	Name4
	Name5
	Name6

Result I Need
Code	Description
A	Name1
B	Name2
C	Name3
D

I learnt that we can use join functin in power query window but i like to undersatand, is there any other method availble in visualizatiom

Thanks,

Santhosh R

[msbiuser1]

@saravanan_p  Thats tricky and seems to be simple. @santhoshrama  Kindly mark this as solution. Thanks

[saravanan_p · Accepted solution]

Hi,

Use table matrix and drag elements from second table.

(Code and Description )

Now use filter pane , go code and untick blanks. 
You get the result.

Kindly mark as solution and thumps up for keeping community healthy

 

 

[santhoshrama]

Hello,

Thank you..it's a simple & easy solution