Filter few rows out of all the rows

[Anonymous]

Hi experts,

I hope everyone is doing fine. 

I am confronting a problem and hoping to get your help. 

I have a table in PBIX File, be It any kind of table but supposingly I have two columns displayed in front of me. 

I want to filter the table and display only that part in which both the columns will have a value. If any column value is empty,I do not want to display Its corresponsing value as well.

NAME	ADD
A	ABC
B	CDE
C	FGH
D	ABC
E	GFH
F	DKD
G	EDIE
H	DHS
I	SLF
J	VZK
K	CDK
L	CQP
M
K
O
P
Q
R
S
T
U
V
W
X
Y
Z
A
B
C
D
E
F
G

For Example- I want to display the upper values in which both columns have values and remove the lower part of NAMES in which there is no corresponsing value. How Can I do that?

I hope you understood my problem.

[jaideepnema · Accepted solution]

Hi @Anonymous ,

Did you tried applying a visual level filter on both the columns as shown below ?

Please accept this as a solution if your question has been answered !!

Appreciate a Kudos 😀

[Anonymous]

Thank you very much.