Forum Discussion
Creating a filtered table via a contains function
Hi cartman21,
If the investors name are in fixed location in your resource table. In Query Edit navigator, you split the column into separate columns by delimiter(blank), get the investors column like the example you given above, then you can the solution posted by MFelix.
In addition, from the screenshot below, the column is the investors or company fields? Could you please give more details, so that we can post the solution which is close to what you want.
Best Regards,
Angelia
Sorry I think my description was not good enough.
So basically, I have an API which I have created a report with in Power BI.
Here is the table I have working:
If i use a delimiter, I get in row 4 for example different columns such as:
My issue is i need to be able to search in the report (not in the query/backend) for say, 360 capital.
I have tried the slicer, but then I have to select each iteration of 360 capital that shows up. Is there a way I can just type in a string into a slicer/search and all companies with investors matching the string show up in the table?
Here is the problem with the slicer----
and i can't find a 'select all' feature.
Any help with this would be greatly appreciated!!