Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
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
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
11 | |
9 | |
6 |