Forum Discussion
Displaying a Hierarchy with attributes
Super UserTo display this in Power BI with drill-down functionality, you could try this approach:
1. Set Up a Hierarchy Visual:
- Import both tables into Power BI and link them via the `Node` column.
- Use a Matrix or Tree Map visual for the hierarchy. Add `Node` and `Description` from the Hierarchy table, setting them as a hierarchy in the visual, so users can expand/collapse levels.
2. Show Access Roles:
- Add the `Role_description` from the *Node Access* table to the Matrix visual to display roles associated with each node.
- If you want a detailed role view, set up a drill-through page with `Node` as a filter, and add `Role_number` and `Role_description` as a table. Users can right-click a node and drill through to see access roles.
This setup should let users explore the hierarchy and view roles for each node easily.
neither of those visuals really display the hierarchy correctly
I tried a couple of custom visuals, and although they did display the data, having such a big hierarchy meant you couldnt actually see the data
(idealy clicking on a node would make that the top level, and then just display children from there, with teh ability to click on one of those child nodes to then display it as the top node)
I have more or less come to the conclusion that PowerBI isnt the way to go here