Forum Discussion
Problem with linking a Decomposition Tree to a definitions table
Hi,
We’ve built a Decomposition Tree in Power BI to visualize our Application Capabilities.
Each capability has three levels (Level 1, Level 2, Level 3), and each level has its own code, name, and definition.
Next to the decomposition tree, we’ve added a table visual that displays the definitions of these capabilities.
Now, we’re facing two main issues:
- We’d like the decomposition tree to be connected to the definitions table — meaning when a user clicks on a capability in the tree, the corresponding definition shows up in the table.
- When a user clicks on a Level 3 capability, we’d like the table to show not only its definition but also the definitions of the related Level 2 and Level 1 capabilities above it.
We’re also wondering if the Decomposition Tree is even the best visual for this kind of hierarchical data, or if there’s a better approach to achieve this interaction.
Any ideas on how to build or link this properly would be appreciated.
JavadiSH How is your Decomposition Tree visual configured? It's not clear from your description but overall, no, this is likely not the best use of a Decomposition Tree visual and you might be better off using a simple Matrix visual for this. Sample data and a bit more information could go a long way in helping to figure out a proper solution.
Agree with GeraldGEmerick. The Decoposition Tree is not the best visual for your use case:
It doesn't support cross-filtering other visuals in the way you need. For your use case, I'd recommend switching to a Matrix visual instead.
Why Matrix is better here:
- Native cross-filtering support - clicking any level automatically filters your definitions table
- Shows hierarchy clearly with expand/collapse
- More predictable interaction
4 Replies
JavadiSH How is your Decomposition Tree visual configured? It's not clear from your description but overall, no, this is likely not the best use of a Decomposition Tree visual and you might be better off using a simple Matrix visual for this. Sample data and a bit more information could go a long way in helping to figure out a proper solution.
Agree with GeraldGEmerick. The Decoposition Tree is not the best visual for your use case:
It doesn't support cross-filtering other visuals in the way you need. For your use case, I'd recommend switching to a Matrix visual instead.
Why Matrix is better here:
- Native cross-filtering support - clicking any level automatically filters your definitions table
- Shows hierarchy clearly with expand/collapse
- More predictable interaction
Hi JavadiSH,
Thank you GeraldGEmerick and Shai_Karmani for your answers to the query in this community.
Just wanted to follow up and confirm that everything has been going well on this. Please let me know if there’s anything from our end.
Please feel free to reach out Microsoft fabric community forum.Hi JavadiSH,
Just wanted to follow up and confirm that everything has been going well on this. Please let me know if there’s anything from our end.
Please feel free to reach out Microsoft fabric community forum.
