Create Hierarchy for Child tables

[aar1]

In my database (sharepoint list) each entry has a unique ID and each ID can have 0 or many 'attachments'. SharePoint lists store attachment URLs and I need the web urls to be clickable so users can see attachments. In my table I would like to create a hierarchy where you can expand the attachment column (like how 'date' can be expanded) to view the attachments. I have tried creating and adding hierarchies with ID and attachments but this does not work. Whenever an entry has multiple attachments duplicate rows are created instead of showing the expandable sub tables. For example in the image below 'AI Driller' is ID 9 and has 2 attachments. But the rows are shwoing twice. How can I work around this?

[Ritaf1983 · Accepted solution]

Hi @aar1 

If I understand you correctly you should use a matrix and just put your categories in their hierarchial order.
like in my example:

If there is something else 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly