Filtering several collumns based on just one stattement

[acbisogni]

I have a situation that I believe should th easy to solve.

I have several classification collumns, and I need to filter my database based on one single statement. Resumed example below:

If I write ERP in the input field for the filter, I got the table filtered showing just entries 1 to 4, but if I enter Rise in the same input filed, I got the table filtered showing only the entries 1 and 2. Is that possibel?

ID	Class1	Class2
1	ERP	Rise
2	ERP	Rise
3	ERP
4	ERP
5	Infra	Network
6	Infra	Network
7	Infra	Server
8	Comm	Signal
9	Comm	Signal
10	Comm

Thanks, Adriano

[mahenkj2]

Hi @acbisogni 

1. If you have just 2 or a few column, concatenate in power query with & operator and create a new column.

2. Reference this table as another table, remove all columns, remove duplicates. Create relationship of this column with main table concatenate column.

3. Use slicer from table of item 2 above

I do not think above as a good idea, but if you need just as a filter.

Hope it helps.

[lbendlin]

I am not aware of any slicer visual that allows you an OR search over multiple columns.  You can fudge it somewhat by using disconnected tables, independent slicers, ISFILTERED, and a measure.  Lots of effort.