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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.