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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
wizard23
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?

2 REPLIES 2
wizard23
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

vicky_
Super User
Super User

vicky__0-1680039888706.png

vicky__1-1680039911589.png

 

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

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.