Forum Discussion
Solved
Filter based on content
Hi, I have a list of data in a column, some of the data contains the letters CE and some contains F&O. I need a filter with two options, CE or F&O, that when selected, only selects the data whic...
Hi,
Thanks for the solution hackcrr offered, and i want to offer some more information for user to refer to.
hello sbott , based in your description, you cannot change the datasource, you can craete a measure to filter the data, you can refer to the following solution.
Sample data
Create a measure.
Count = COUNTROWS(FILTER('Table',CONTAINSSTRING([Word],"CE")||CONTAINSSTRING([Word],"F&O")))Then put the measure to the visual filter.
Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
