Slicer to search two columns and return all instances of a record

[asrjcb]

I'm looking for some help to create a slicer that would show any record with the slicer selection OR another column that is not the slicer column. Example sheet attached that is more clear.

If it can't be done in a slicer, I'd be interested in other non-coding or Power BI solutions.

Thanks!

 

[Chihiro]

Here. See attached.

Process:
1. Convert data range into Excel table and load to PowerQuery(PQ) and go into the editor.
2. Duplicate "Resources" column.
3. Split the duplicated column by delimiter ";"
4. Unpivot split columns
5. Remove "Attribute" Column.
6. Trim text on Value column.
7. Load the result to data model
8. Create Pivot Table (add Site, Address, Name, Resources to Row Label).
9. Use "Value" column as source for Slicer.

FYI - You can use formula to transform table like it's done in PQ. Though there will be more overhead, and bit harder to make it dynamic.