Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I am quite new to Power BI and i'm trying to filter one table based on a partial text match from another table.
Table1: Products
ProductID Description
1 Rolex 1995 Men's Watch
2 Submariner Wall Clock -Rolex
3 Compact Processor/Blender
4 Prolex Cordless kettle
Table2: AlertTerms
Term
Rolex
Watch
Car
Motorcycle
I want to have table 2 as a slicer and when I select Rolex, only products 1 & 2 show up, Not product 4. Is there any way to do this?
Any help will be appreciated. Thanks
Hi @Atifz ,
You could add below measure into fiter pane, set its value to 1.
Check = IF ( ISERROR ( FIND ( SELECTEDVALUE ( 'Term'[Term] ), SELECTEDVALUE ( 'Table'[Description] ) ) ), 0, 1 )
hi @v-eachen-msft,
Thanks for this.
It works for some of the terms but there are issues with different cases or space before the search term.
e.g 1: If the search term is "Rolex", it will not show "rolex" or "ROlex"
e.g 2: If the term is " rolex", it will not show "rolex".
Is there a way to modify the DAX to include all varients of the search term and not just the exact match?
Thanks.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
71 | |
70 | |
38 | |
26 | |
26 |
User | Count |
---|---|
99 | |
87 | |
45 | |
43 | |
35 |