Word search by report users

[Sambath]

Hello Power BI Gurus,

I have a very simple requirement: users want to type a word or a phase and it filters all visuals within a page.

I have a table with a free text column; called [Description] where people type anything; and I want to create a report, with many visuals. I want to create a text box where report users can type a word or a phrase, for example: "Word", "word" or "WORD", and it filters all visuals on a report page. Looked into FIND, SEARCH, CONTAINSTRING and CONTAINSTRINGEXACT but could not figure out how to achieve this. I cannot use custom visuals. 

Any advise? 

Thanks in advance. 

[MFelix]

Hi @Sambath ,

Currently you have the new Text Slcer that allows you to do this is on preview on Power BI Desktop.

https://community.fabric.microsoft.com/t5/Power-BI-Community-Blog/Introducing-the-new-text-slicer-in...

[Irwan · Accepted solution]

hello @Sambath 

if you can not use custom visual, i think the best way is using Page Filter which placed at below Visual Filter.

Page Filter will filter all visual in Page (you need to assign Page Filter to each Page if you have multiple Pages) while Visual Filter is only filtering on certain visual.

Also you need to open Filter Pane so user can use Filter Pane but it is open by default.

User can use advace filtering and choose any filter method they want. EXACT or CONTAIN

Hope this will help.

Thank you.