Filter a column with another column

[Anonymous]

Hi,

This is my problem : 

I have data like this

Name Column2 Column3

name1 ...

name2 ...

...

name200 ....

And I have an other data (excel format) with juste a name column like this : 

Name

name1

name2

...

And I want to filter the first dataset with just the name of the excel file

How can I do this ?

Thanks !

[v-zhangti · Accepted solution]

Hi, @Anonymous 

You can try using a slicer after creating a relationship for two tables.

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jaipal]

@Anonymous Create relationship between two tables with Name columns.

Then you able to filter one table by using another table