Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

Create a search box to search on multiple columns

I am trying to create a multi-search text box . Lets say if i want to search either by customer name or customer ID.

I want to give the user the ability to click on either customer name / customer id and then the search/slicer should show a drop down of those . 

How do i go about this?

Frequent Visitor

Rather than a hierarchy slicer , would a text filter slicer be possible , to search either A or 1 . And i was looking for a partial search eg if customer name is Aaron . if i type Aa , it should populate . I do know there is a custom text filter to do this . But from what ive found concatenation the only way to obtain a multi-column partial search . I was hoping there is another way

Super User
Super User




You can just add both fields to the slicer and it should work

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors