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
Anonymous
Not applicable

Need global search filter in powerbi

Need a global search fiter like google search in powerbi.

As checked in powerbi visuals there is a text filter but, when we are using the text filter we should combine all the columns by creating a new columns. In our case, we don't want create any column or measure since we will face . Just we want some functionality to get a global search to search all column data.

1 ACCEPTED SOLUTION
HarishKM
Power Participant
Power Participant

@Anonymous Hey,
you can read this blog Easy method for global filters on Power BI - BI (utashnanunkoo.com).

Thanks
Harish M

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

HI , Thanks for the response. 

As you shared link , it is helpful only for 3 or 4 filters .But in my case i am having a 50 unique columns and  i can't add all column into report level filters. So we want to give simple search option in main page. So kindly help me the soution how to add search for all the data as like  as google search bar.

@Anonymous You can use table visual and use slicer to slice and dice the record based on the requirement .
Example 
In below example I have added important Slicer based on busines requirement to slice and dice and I have drag all neccessary column in table. Now I can select required slicer to extract unique record....


HarishKM_0-1684250881812.png

Extract : highlighted icon to extract data .

HarishKM_1-1684251106053.png

 

 

Thanks 
Harish M
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!



 

 

Anonymous
Not applicable

Thank you for your clear explanation. I know slicer is helpful for each and individual column.

But i want to search the all the columns  data in single filter or single slicer..

HarishKM
Power Participant
Power Participant

@Anonymous Hey,
you can read this blog Easy method for global filters on Power BI - BI (utashnanunkoo.com).

Thanks
Harish M

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

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!

Feb2025 NL Carousel

Fabric Community Update - February 2025

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