Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to 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
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
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