Forum Discussion

Mighty_Andrew's avatar
Mighty_Andrew
Regular Visitor
4 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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