Hi,
I have a table called "Customers".
|Customer | Customer Code | Owner|
I would like to create a Power Bi Report where a user is able to type in either the name of the Customer or the name of the Owner into a search bar and have a list populated showing the "Owner" and "Customer" based on what has been typed/searched.
I would like the report to display only the search bar and the remainder of the page to be blank. Once the user begins searching, I would like the user to then see a table populated below with the results. The table should be blank whilst the search bar is empty.
The methods I have tried so far are:
"Text Search Slicer" Visual with a "Card" Visual. This only allows for one entry to show in the card.
"Smart Filter by OKVIZ" this provides a list under the search bar but if I were to Type the letter "A" I would see all Accounts with the letter A anywhere in the name.
When I have used the "Text Search Slicer" with a Table, the table remains populated with all Customers and Owners until a term has been searched and I need the table to remain blank until the term has been searched.
If anyone can provide any help with this, that would be massively appriecated.
