Forum Discussion

LinhNguyen's avatar
LinhNguyen
Helper II
6 years ago
Solved

Create a search box across multiple fields

Hi everyone!   I'm looking for a way to create a search box that can search through multiple fields. (as in the image below). So far I've tried the text filter and filter by list but both only let ...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Tahreem24's avatar
    Tahreem24
    6 years ago

    Hi LinhNguyen ,

     

    I got finally what you were aksing for. Please use the Custom visual "HierarchySlicer" from market place. And Create you own hierarchy like I created for testing purpose on Date - Year-->Quarter -->Month-->Day. Screen shot is attached for your reference.

     

    Please give Kudos and also accept this as a solution.

DavidSalas's avatar
DavidSalas
New Member
5 years ago

I am not too keen about the use of a hierarchical slicer for this. 

 

I think the best way to accomplish this is to use the Search Text Visual against a computed column that concatenates all the columns that you want to include in the search. Your results will then be filtered by whichever match is made against this column. Unless you are using DirectQuery, you can create this column directly from Power BI. Alternatively you can create this column directly on your data source and expose it to Power BI.