Forum Discussion
Restrictive multiple selection
Dear colleagues,
After looking for a solution without any success, I was wondering whether you could answer my question.
I have a matrix visual I want to filter its output by using a slicer that I placed on top of it.
The main problem I have is that whenever I select multiple values in the slicer, my table does not understand that I'm only looking for exact matches.
Just to give you an example, this is the current output when I select two skills (Python and SQL) from the slicer:
| ID | Python | SQL |
| Emp_1 | 4 | 4 |
| Emp_2 | 4 | |
| Emp_3 | 3 | |
| Emp_4 | 3 | 1 |
What I would like to get:
| ID | Python | SQL |
| Emp_1 | 4 | 4 |
| Emp_4 | 3 | 1 |
Is there any way to achieve this? In fact, I'm using a card visual to count and show the number of matches. As you will understand, it's performing as bad as my table.
Thank you!
Hi, Anonymous ;
You could create a new table then create a flag measure.
1.create a new table as slicer
slicer = VALUES('Table'[cate])2.create a flag measure.
flag = IF( CALCULATE(DISTINCTCOUNT('Table'[cate]),FILTER(ALL('Table'),[ID]=MAX('Table'[ID])))=DISTINCTCOUNT(slicer[cate]),1,0)3.apply the flag measure into filter
The final output is shown below:
Not sure you understand your logic correctly? If not, please correct me and provide more information.
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
v-yalanwu-msftCommunity Support
Hi, Anonymous ;
You could create a new table then create a flag measure.
1.create a new table as slicer
slicer = VALUES('Table'[cate])2.create a flag measure.
flag = IF( CALCULATE(DISTINCTCOUNT('Table'[cate]),FILTER(ALL('Table'),[ID]=MAX('Table'[ID])))=DISTINCTCOUNT(slicer[cate]),1,0)3.apply the flag measure into filter
The final output is shown below:
Not sure you understand your logic correctly? If not, please correct me and provide more information.
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Dear v-yalanwu-msft ,
First of all, sorry for my late reply.
In fact, I tried to do it your way but still could not achieve my goal.
I wish I could share the pbix file, but this platform doesn't allow me somehow.
Please access my files (containing dummy data) through the link below: (as I cannot attach any here)
Thank you very much,
- amitchandak
Super User
Anonymous , if you have taken slicer and selected values emp_14 and emp_43, t should give that, if the two visual are interacting.
Hope interactions is not off
https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions
Hi amitchandak,
I'm sorry, just realized the table isn't somehow reflecting what I typed in...
The current output looks like this:
Python SQL
Emp_1 4 4
Emp_2 4
Emp_3 3
Emp_4 3 1
Therefore, my desired output is:
Python SQL
Emp_1 4 4
Emp_4 3 1
Looking at interactions was the very first thing I did. It's very weird since I switched off the other slicers andd this slicer is actively filtering the table (not highlighting).
I believe the issue lies in the fact that my slicer allows for multiple selection, but doesn't perform an inner join.
Thank you,
