Forum Discussion
Solved
Visualization filter based on selection that contains similar text in another column
Hello, Im looking for the way to solve this case: I want to choose in filter visualization [TABLE_X]Product = "Board", then visualization should show me every "Product" that has value in [TABLE_X]M...
Hi Mighty_Andrew ,
Here are the steps you can follow：
1. Enter Power query, select [MPN], and click Home – Split Column.
2. Select [MPN.1], [MPN.2], [MPN.3], [MPN.4], [MPN.5] that form the table, and click Transform – Unpivot Columns.
Result:
3. Create calculated table.
Slice = DISTINCT('Table'[Product])4. Create measure.
Flag = var _selectedvalue=SELECTCOLUMNS(FILTER(ALL('Table'),'Table'[Product] in ALLSELECTED(Slice)),"1",'Table'[Value]) return IF(MAX('Table'[Value]) in _selectedvalue,1,0)5. Place [Flag]in Filters, set is=1, apply filter.
6. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
hi
another solutions
1.make duplicate of the table
2.make a relation between table1[mpn] and table2[mpn]
3.add table1[product] to a slicer
4. add table1[mpn] and table2[product] to the table
if this post hepls ,accept it as a solution