Create Hierarchy for Child tables

Question

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 Answer

Hi&nbsp;aar1&nbsp;If I understand you correctly you should use a matrix and just put your categories in their hierarchial order.like in my example:&nbsp;If there is something else&nbsp;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&nbsp;If this post&nbsp;helps, then please consider&nbsp;Accepting it as the solution&nbsp;to help the other members find it more quickly

Forum Discussion

Create Hierarchy for Child tables

1 Reply

Related content

Create new table

Lakehouse Table Generate Create Table

How to create hierarchy not in fct table or based on integer key columns?

Create rows from 2 tables

Creating Hierarchy "Backwards"