How to create a multi-field search object

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.