Filter from two columns in same table

[Qotsa]

Hi,

How would I go about returning filter results based on these two columns.

Would like a search box where I type in the employee or client name and the table would filter as below.

[jaipal · Accepted solution]

@Qotsa  download the file from this link

https://www.dropbox.com/s/2je9a8fge9sytz6/Filter%20Emp_client.pbix?dl=0

[amitchandak]

@Qotsa , You can try text filter

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381309?src=office&tab=Overview

You can create a concatenate column with both and us that filter

filter column = [Employee] & " " & [Client]