Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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
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
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |