Use slicer to a filter table based on values in multiple columns

[Bel]

Hi, 

I am trying to filter a table of clients based on whether their account meets a certain criteria.

	Criteria 1	Criteria 2	Criteria 3	Criteria 4	Criteria 5	Criteria 6
Client 1	NO	YES	NO	YES	NO	YES
Client 2	YES	NO	NO	NO	NO	NO
Client 3	YES	NO	NO	NO	NO	NO
Client 4	YES	YES	YES	YES	YES	YES
Client 5	YES	NO	NO	YES	YES	YES

I want the slicer to be a list of the criterias.  Then if I select Critera 3, the table will filter to just show Client 4 (being the only Client who said YES to Criteria 3).

Any help appreciated.

Bel

[Zubair_Muhammad · Accepted solution]

Hi @Bel

Just Unpivot your Criteria columns

It will give you ALL criteria under one Column

Then you can create a SLICER for that column

After unpivoting you will get

[Anonymous]

 Hello Zubair,

Please, in my scenario I have two Sharepoint list multivalues column like ";#India;#China;#Japan;#Korea" and another column like ";#Gold;#Silver;#Iron". 

I need to filter rows that contains "Silver and China" or just "China". Do you have any idea.

Thanks,

Augusto