cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Bel Visitor
Visitor

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

Hi, 

 

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

 

 Criteria 1Criteria 2Criteria 3Criteria 4Criteria 5Criteria 6
Client 1NO YESNOYESNOYES
Client 2YESNONONONONO
Client 3YESNONONONONO
Client 4YESYESYESYESYESYES
Client 5YESNONOYESYESYES

 

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

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

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

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

 

1013.png

 

After unpivoting you will get

 

1014.png

2 REPLIES 2
Super User
Super User

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

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

 

1013.png

 

After unpivoting you will get

 

1014.png

Highlighted
AugustoGMAraujo Frequent Visitor
Frequent Visitor

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

 

 

 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

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 61 members 1,302 guests
Please welcome our newest community members: