Forum Discussion

cham's avatar
cham
Post Patron
7 years ago
Solved

Filter Names

Hi, I want to filter specific names in my filter. How I can do that?   I am having following data set. In my slicer I want to show only names that mentioned in that column (Ex:Peter, Jack, Mary) O...
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • MariaP's avatar
    MariaP
    7 years ago

    Hi cham ,

     

    It's best to supply sample of your data so community can better help. It depends on how consistant the content of the rows you want to exclude  is.

    You can try the same as idea as mentioned but this time use the excluding option for the fields you do not want if you know they will always be the same. It is not an exact match so Driver or Customer is enough to exclude :

    #"Filtered Rows" = Table.SelectRows(#"Changed Type", each not Text.Contains([Column1], "Driver:Land") and not Text.Contains([Column1], "Customer Service"))

     

     

     

    Another option may be to create a new table with only the names as a reference table.

     

    Maria

cham's avatar
cham
Post Patron
7 years ago

Hi Maria,

 

No it contains other numbers with "(". Like below,

 

Drivers - Land: (8043489384)

 

Is theer any other way to capture that details?

 

Thanks,

cham

MariaP's avatar
MariaP
Solution Supplier
7 years ago

Hi cham ,

 

It's best to supply sample of your data so community can better help. It depends on how consistant the content of the rows you want to exclude  is.

You can try the same as idea as mentioned but this time use the excluding option for the fields you do not want if you know they will always be the same. It is not an exact match so Driver or Customer is enough to exclude :

#"Filtered Rows" = Table.SelectRows(#"Changed Type", each not Text.Contains([Column1], "Driver:Land") and not Text.Contains([Column1], "Customer Service"))

 

 

 

Another option may be to create a new table with only the names as a reference table.

 

Maria

  • cham's avatar
    cham
    Post Patron
    7 years ago

    This would work. Thank you so much.