Forum Discussion
Filter does not contain the word
Hello
I'm having a lot of trouble trying to develop the following in Power BI. I have a table called Master that contains a column of product titles, called titles. I need to put two text filters so that the user can add two words, one which is the word he wants the title to contain and the other the word he wants the title not to contain, these filters must filter the data and display the resulting titles in a visualization.
That's the beauty of a filter - unless you lock it or have it hidden the user will be entering the values in the filter.
7 Replies
- audreygerred
Super User
You can add your filter for title field to your filter pane, then select Advanced filtering for filtering type and set the first condition to contains and the second to does not contain:
Thanks for your help. This solution is not what I need since the word to be filtered is not constant, it changes according to the user's desire.
- audreygerred
That's the beauty of a filter - unless you lock it or have it hidden the user will be entering the values in the filter.
- danextian
Hi perobert ,
Please provide more info. Are the filter words constant or with the use of slicers? Are those that contain and those that don't will be used in different visuals. Please provide a sample data we can work on plus the expected result from that sample data. This should serve as a guide: https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/td-p/1447523/jump-to/first-unread-message
Thanks for your help. They are not constant, the use of segmenters is required so that a person who is using the dashboard can enter the words they want. They will not be displayed in different visuals, I need the result table to show the titles that contain word 1 and at the same time do not contain word 2
