Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
SimuQuery
Frequent Visitor

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 

1 ACCEPTED SOLUTION
v-heq-msft
Community Support
Community Support

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

vheqmsft_2-1731477662146.png

 

Create a calculate table

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

Final output

vheqmsft_1-1731477601416.png

 

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

 

 

 

 

 

View solution in original post

3 REPLIES 3
v-heq-msft
Community Support
Community Support

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

vheqmsft_2-1731477662146.png

 

Create a calculate table

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

Final output

vheqmsft_1-1731477601416.png

 

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

 

 

 

 

 

Thanks for this! 

FarhanJeelani
Super User
Super User

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😊

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Top Solution Authors
Top Kudoed Authors