Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
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.
Solved! Go to Solution.
I have resolved this 😄 I used the measure:
I have resolved this 😄 I used the measure:
 
					
				
				
			
		
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
 
            | User | Count | 
|---|---|
| 85 | |
| 49 | |
| 36 | |
| 31 | |
| 30 |