Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Filter a column with another column

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 !

Need Help
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    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.

2 Replies

  • jaipal's avatar
    jaipal
    Resolver III
    4 years ago

    Anonymous Create relationship between two tables with Name columns.

    Then you able to filter one table by using another table

  • v-zhangti's avatar
    v-zhangti
    Community Support
    4 years ago

    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.