cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Filter ids being in EACH of the selected groups

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:

 PB1.pngPB2.png

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:

 PB3.pngPB4.png

, 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

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

Re: Filter ids being in EACH of the selected groups

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!

 

View solution in original post

3 REPLIES 3
Super User IV
Super User IV

Re: Filter ids being in EACH of the selected groups

Does my In Common Quick Measure help here?

 

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

 


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Community Support Team
Community Support Team

Re: Filter ids being in EACH of the selected groups

@Anonymous,

 

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

HierarchySlicerUsage.gif   

 

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.

 

 

Anonymous
Not applicable

Re: Filter ids being in EACH of the selected groups

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!

 

View solution in original post

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors