Forum Discussion
Seperating by text contains
Hi,
So I'm looking at setting up a new dashboard for a workflow that will be composed of tasks of the same work item type, for this reason I will be unable to filter by this alone. Am I able to create a new table using some kind of 'text contains' function? And would this create issues as they will all have the same parent ID (the workflow will be a composite of tasks under a document), for example when I try and organise by document / project. I know I've been pretty vague here but any high level info on how possible this is would be helpful
Hi Anonymous ,
Thanks for FarhanJeelani reply, here is a realization version.
Sample dataCreate a calculate table
Filtered Table = FILTER( 'Table', CONTAINSSTRING('Table'[Project], "A") )Final output
Best regards,
Albert HeIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
3 Replies
Sure! You can use Power Query or DAX to create a new table where tasks are filtered by "text contains" functions. This helps classify tasks even if they share the same parent ID. Try adding unique identifiers for each task or use composite keys (like "DocumentID-TaskID") to organize them by document or project. Slicers or visual filters will also let users filter dynamically by keywords, projects, or documents in the dashboard.
Please mark this as a solution if it helps. Appreciate Kudos😊
Hi Anonymous ,
Thanks for FarhanJeelani reply, here is a realization version.
Sample dataCreate a calculate table
Filtered Table = FILTER( 'Table', CONTAINSSTRING('Table'[Project], "A") )Final output
Best regards,
Albert HeIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
