Seperating by text contains

[SimuQuery]

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 

[Anonymous · Accepted solution]

Hi @SimuQuery ,
Thanks for FarhanJeelani  reply, here is a realization version.
Sample data

Create a calculate table

Filtered Table = 
FILTER(
    'Table',
    CONTAINSSTRING('Table'[Project], "A")
)

Final output

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[SimuQuery]

Thanks for this! 

[FarhanJeelani]

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😊