Forum Discussion
Filter Column based on values from other column
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.
1 Reply
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
