Forum Discussion
How to create a multi-field search object
Hello,
i want to create a search objet multi-field with wild card.
How to do taht ?
Reagrds,
Sophie
Hi Sophie__
Power BI does not currently provide native support for wildcard searches, and it does not allow searching across multiple fields at the same time. The built-in Text Slicer only supports a contains search; options such as begins with or ends with are not available.
To enable searching across multiple fields when all columns are in a single flat table, the usual workaround is to concatenate the relevant columns into one and use that combined column in a Text Slicer, as suggested by Ritaf1983 @Ritaf1983
When the fields to be searched are spread across multiple dimension tables and the fact table only contains foreign keys, this workaround becomes much more complicated to implement and one possible downside is an increased in semantic model size. Please see a sample pbix of such implementation.
4 Replies
Hi Sophie__
Power BI does not currently provide native support for wildcard searches, and it does not allow searching across multiple fields at the same time. The built-in Text Slicer only supports a contains search; options such as begins with or ends with are not available.
To enable searching across multiple fields when all columns are in a single flat table, the usual workaround is to concatenate the relevant columns into one and use that combined column in a Text Slicer, as suggested by Ritaf1983 @Ritaf1983
When the fields to be searched are spread across multiple dimension tables and the fact table only contains foreign keys, this workaround becomes much more complicated to implement and one possible downside is an increased in semantic model size. Please see a sample pbix of such implementation.
Hi Sophie__
Unfortunately, a native multi-field wildcard search object does not currently exist in Power BI. Each slicer or search box is restricted to a single column.
However, you can achieve this functionality using the following workaround:
Create a Unified Search Column: In DAX or Power Query, create a calculated column that concatenates all the fields you want to search. For example: SearchField = [Column1] & " " & [Column2] & " " & [Column3]
Use the Text Filter Visual: Download the Text Filter custom visual (by Microsoft) from the AppSource. Map this visual to your new "SearchField" column. It supports wildcard-style searching (contains) across all the data combined in that column.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi Sophie__,
Checking in to see if your issue has been resolved. let us know if you still need any assistance.
Thank you.
