Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
I have 3 tables importing from SQL database:
- unique list of news articles (columns: ItemID, URL, Title, ...)
- unique list of available tags, that editors used with the news articles (columns: TagID, TagName)
- bridge between news articles and tags (columns: ItemID, TagID), each item can have multiple tags (multiple rows with the same ItemID)
How can I visualize a table that would list the news articles and for each row show all the assigned tags, e.g. comma separated in a single column? Now I get as many rows for each article as the number of tags assigned to it.
Solved! Go to Solution.
Hi @rmarian ,
We can use the following steps to meet your requirement.
1. Change the relationship direction between bridge table and tags table to Both.
2. Then create a measure, and get the result like this,
Measure = CONCATENATEX(VALUES(tags[TagName]),tags[TagName],", ")
If it doesn’t meet your requirement, could you please show the exact expected result based on the table that we have shared?
BTW, pbix as attached.
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @rmarian ,
We can use the following steps to meet your requirement.
1. Change the relationship direction between bridge table and tags table to Both.
2. Then create a measure, and get the result like this,
Measure = CONCATENATEX(VALUES(tags[TagName]),tags[TagName],", ")
If it doesn’t meet your requirement, could you please show the exact expected result based on the table that we have shared?
BTW, pbix as attached.
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This works like a charm! Exactly what I needed - thank you!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
75 | |
54 | |
37 | |
31 |
User | Count |
---|---|
99 | |
56 | |
50 | |
42 | |
40 |