How best to visualise text/string based data?

[Bekah]

Hello all!

I've been using Power BI to build a benchmarking database for a particular product. This involves a central dimension table with one to many relationships to fact tables, each of which contains the numerical data for a particular test (e.g. tensile strength, surface hardness, etc.). This data I can manipulate via some admittedly pretty basic DAX (still quite a beginner!) and visualise without issue.

But I now have reverse engineering type data which outputs as strings rather than numerical data and I cannot work out how to deal with it at all. What I would like is to have a slicer of sample names that filters something like a pie chart to show the multiple consituent chemicals identified by reverse engineering. I can do this as a multi-row card but it's ugly and a bit hard to read. I'm also not sure how best to organise the data tables... Any help would be appreciated! 

Here are the two different ways I've formatted the tables:

Here's the multirow card- which is clearly not up to scratch- I've made:

I've looked around for solutions and I think I maybe need nested tables but I'm not sure if I'm just overcomplicating the situation - I'm also wondering if concatenateX would come in handy here...

[Deku · Accepted solution]

Why not just have table version 2 and return a table visual?

[Bekah]

I could and that does work better than a multi-row card, it's just rather visually unappealing but that might just have to be a bullet for me to bite...

Have you much experience in working with strings in PowerBI? Do you have any particular reccomendations for how best to deal with strings rather than data? 

[Deku]

Tables or cards are the only option. If you want in line, then use concatenatex. When when you want a single value a table still scales the best