Forum Discussion
Word search by report users
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.
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.
2 Replies
IrwanSuper User
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.
