Filter Column based on values from other column

[Basdo]

Hi,

I have data of this format

Key	ID
A	1
A	2
A	3
B	3
B	4
C	5
D	6
E	6
E	7

Now I would like to filter by all IDs that are "connected" with eachother by Keys

For example:  ID 1 -> Key A -> ID2, ID 3 -> Key B -> ID 4

So the groups of IDs provided by the table above would be:

Group1:   1,2,3,4

Group2:   5

Group3:   6,7

Now I would also love to use these groups as filters  / slicers in my visual.

I'm thankful for any ideas.

[Anonymous]

Hi @Basdo,

In fact, the grouping rules that you mentions are hard to reproduce the group information in your sample table.

AFAIK, power bi data mode tables do not include row and column index. For this scenario, you can simply add tag to table to confirm if the specific category has continuous records. They will need to be coding complex conditions to check and exclude specific records.

Regards,

Xiaoxin Sheng