Hi everyone,
I have a problem that I am facing right now. I have a table which shows like this:
I want to create a slicer that can filter my table by the certifcation the staffs has. I have a slicer that looks like this right now:
Right now, when i choose A, it will only show Henry.
I want my slicer to look like this:
If i were to choose A, I want my table to show everyone who has the certificate A, which means in my case, it should be able to show John, Henry, Brian.
Thank you! Appreciate any help i can get.
Solved! Go to Solution.
Hi @Afiq_Danial ,
Please try below steps:
1. below is my test table
Table:
Table(2):
2. create a measure with below dax formula
Measure =
VAR cur_select =
SELECTEDVALUE ( 'Table (2)'[Column1] )
VAR cur_cert =
SELECTEDVALUE ( 'Table'[Certification] )
RETURN
IF ( CONTAINSSTRING ( cur_cert, cur_select ), 1 )
3. add a slicer with Table(2) field and add a table visual with Table fields, add measure to table visual filter pane
Please refer the attached .pbix file.
Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Afiq_Danial ,
Please try below steps:
1. below is my test table
Table:
Table(2):
2. create a measure with below dax formula
Measure =
VAR cur_select =
SELECTEDVALUE ( 'Table (2)'[Column1] )
VAR cur_cert =
SELECTEDVALUE ( 'Table'[Certification] )
RETURN
IF ( CONTAINSSTRING ( cur_cert, cur_select ), 1 )
3. add a slicer with Table(2) field and add a table visual with Table fields, add measure to table visual filter pane
Please refer the attached .pbix file.
Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Afiq_Danial Easiest way would be to split your column in Power Query and unpivot the columns. Otherwise, you could use a disconnected table for you slicer and a Complex Selector where you use SEARCH. The Complex Selector - Microsoft Power BI Community
User | Count |
---|---|
136 | |
84 | |
65 | |
60 | |
55 |
User | Count |
---|---|
213 | |
108 | |
86 | |
82 | |
76 |