Filter ids being in EACH of the selected groups

[Anonymous]

Hello everyone! I am stuck with a Dashboard I need to create any help will be greatly appreciated.

I have some ids (e.g. A, B, C,…), and some groups (e.g. gr1, gr2, gr3,…). Each ids belong to certain groups. I need a Dashboard which can filter the ids using the groups. In other words, I want to be able to select certain groups, in order to reduce the list of ids to only the one being in EACH of the selected group.

For now the best I was able to do is the following:

 

i.e. using one filter(i.e. slicer) per group, with one table of ids. The table will show only the ids with the value selected in the filter.

I would like to have only one filter (and not one per group), as I have a lot of groups.

When I reverse the idea of how the data/filter is organized and I can have it this way:

 

, but note that in that case I have all the ids that are in at least one of the selected group, and not in EACH selected group.

Thank you very much!

Best

[Anonymous · Accepted solution]

Hi! Thank you for both interesting answer!

What solved my probelem was to add three measure as explained in this tutorial:

https://medium.com/seismic-data-science/changing-or-to-and-logic-for-power-bi-slicers-1a6b20aee5f5

Note that hierarchical slicer is not enough as a solution.

Thank you for your help!

[v-yuta-msft]

@Anonymous,

According to the requirement, perhaps hierarchySlicer can meet your requirements.

   

Reference: https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380820?tab=Overview

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

Does my In Common Quick Measure help here?

https://community.powerbi.com/t5/Quick-Measures-Gallery/In-Common/m-p/382956