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

Show all grouped that meets all filter criteria

 

Hello to all helpful people Smiley Happy

 

I have a table that looks like this:

 

overview.png

 

I now have two slice filters, once for all AP00XXX names and once for all EXT0XXX.

All these names are available in groups. I have divided the groups with the red lines.

 

I would like to find out in which group the filtered names are present. The combination of the names is always unique.

If I now enter AP00201, AP00307 and AP00404 in the filter all groups should remain from the picture.

Group two has exactly these entries, but all other groups have these entries and more.

 

Unfortunately, the slicer doesn't work that way.
If nothing is filtered everything looks great. There is the group and all names within the group.

As soon as I choose a name in the slicer it shows me the groups in which the name exists, but only the one name. I don't see all entries in this group anymore and it shows me all groups that have at least one of the selected names.

 

To cut a long story short. I need a filter where I can select several entries and it checks if at least all these entries are available in a group. In the list of results I see the group and ALL entries that exist in this group.

 

So if I make the same selection as described above it would show me all groups with all entries on the picture above. If I now additionally enter EXT01010 he only shows me group 4 and everyone else is gone.

 

Does anyone have any idea how I can best implement this?

3 REPLIES 3
NIVA Frequent Visitor
Frequent Visitor

Re: Show all grouped that meets all filter criteria

Is it possible to give the slicer an "and" to combine several things to search for?

Community Support Team
Community Support Team

Re: Show all grouped that meets all filter criteria

@NIVA,

 

You may try adding a measure and drag it to Visual level filters.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
NIVA Frequent Visitor
Frequent Visitor

Re: Show all grouped that meets all filter criteria

@v-chuncz-msft

 

Thanks for your help.

 

I took a look but I don't think I can achieve my goal.

 

Is there a way (perhaps by code) to check what the user has selected in the slicer?
Then I can use this information to filter another object.