Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |