Forum Discussion
text search visual - changing to different fields dynamically.
Power BI does not natively support switching the search field of a text search visual dynamically based on slicer or user selection, as text filter visuals require binding to a single column. However, there are workarounds and custom visual options to achieve your goal:
Recommended Solution: Combined Search Column
Create a new column in your data model that concatenates all target fields (e.g., Category, Product, Customer) using DAX like SearchKey = [Field1] & " " & [Field2] & " " & [Field3].
Bind your text search visual (such as Text Filter or Text Slicer) to this combined column. Users can then search all target fields using a single text box.
This approach simplifies the interface and maintains performance for large datasets.
Custom Visual Alternatives
Custom visuals, such as Smart Filter by OK Viz, may support more advanced filtering (including cascading or multi-field searches).
Explore AppSource for visuals with flexible configuration, but most currently available require a single column for free text search.
Why Measure Does Not Work
Measures cannot be used, as text filter visuals require column-level binding, not measure-based dynamic values.
Steps
Create a search column in Power BI Desktop using DAX.
Use the Text Filter or Text Slicer visual and bind it to the search column.
(Optional) Explore custom visuals for more advanced features from AppSource
Power BI does not natively support switching the search field of a text search visual dynamically based on slicer or user selection, as text filter visuals require binding to a single column. However, there are workarounds and custom visual options to achieve your goal:
Recommended Solution: Combined Search Column
Create a new column in your data model that concatenates all target fields (e.g., Category, Product, Customer) using DAX like SearchKey = [Field1] & " " & [Field2] & " " & [Field3].
Bind your text search visual (such as Text Filter or Text Slicer) to this combined column. Users can then search all target fields using a single text box.
This approach simplifies the interface and maintains performance for large datasets.
Custom Visual Alternatives
Custom visuals, such as Smart Filter by OK Viz, may support more advanced filtering (including cascading or multi-field searches).
Explore AppSource for visuals with flexible configuration, but most currently available require a single column for free text search.
Why Measure Does Not Work
Measures cannot be used, as text filter visuals require column-level binding, not measure-based dynamic values.
Steps
Create a search column in Power BI Desktop using DAX.
Use the Text Filter or Text Slicer visual and bind it to the search column.
(Optional) Explore custom visuals for more advanced features from AppSource
Thank you...this is a great idea, but wouldn't I basically have to create a key to every table in the combined fields that refers to each table?
Yes, that’s correct you’ll need some kind of common key or relationship between the tables to bring those fields together. Usually, something like a TrackID or another unique value that links the tables will do the job.
