Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi all,
I am analysing customer conversations. of each conversation I have a unique ID. conversations can have multiple labels. some of these labels can be grouped /evaluated together. Some should all be present before it can be counted. small example (assume that there are many more conversations, on different days with many more label_names):
| Conversation_ID | Label_name |
| 1 | greeting_call |
| 1 | name_check |
| 1 | zipcode_check |
| 2 | greeting_whatsapp |
| 2 | name_check |
| 2 | zipcode check |
| 2 | birthday_check |
I can show a graph, highlighting that 100% of all conversations have a proper greeting (e.g. if I group _call and _whatsapp to a group proper greeting). However for id_check I can't as only name_ zipcode_ and birthday combined are a proper id_check. It still would like to list these different labels into 1 graph. should I somehow create a new column or something (populating it with all label_names and only for id_check and greeting check if they meet requirements)? Any suggestions for me?
@Anonymous , May a new column like
concatenatex(filter(Table, [Conversation_ID] = earlier([Conversation_ID]) ), [Label_name] , ", ")
Can you share expected output
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 59 | |
| 43 | |
| 42 | |
| 23 | |
| 17 |
| User | Count |
|---|---|
| 190 | |
| 122 | |
| 96 | |
| 66 | |
| 47 |