Forum Discussion
Matrix visual - change root node depending on context
Hello,
I've implemented a matrix that shows a heirarchical organisation structure, with details at the end e.g.
- Org 1 [Totals...]
- Org 2 [Totals...]
- Org 3 [Totals...]
- Detail Field [Values...]
- Detail Field [Values...]
- Detail Field [Values...]
- Org 3 [Totals...]
- Org 2 [Totals...]
Each organisations correspond to a logged-in entity e.g. I could log in as Org 2 and would only see my data. However, because the hierachy is flattened (as per the power BI way of handling heirarchies), I can also see Org 1.
What I want to see is a matrix that's only relevant to the logged in entity and below, in this case excluding Org 1 and starting from myself, Org 2:
- Org 2 [Totals...]
- Org 3 [Totals...]
- Detail Field [Values...]
- Detail Field [Values...]
- Detail Field [Values...]
- Org 3 [Totals...]
The tables are modelled as you'd expect
Org (flattened)
- id
- Org 1
- Org 2
- Org 3
- etc...
Main Data
- id
- field 1
- field 2
- etc
Nb. In the actual implementation of this, there are up to 10 levels in the hierarchy.
2 Replies
RLS is already implemented - the hierarchical data is flattened so if a level 3 entity logs in, we'll still see their level 1 and 2 parents. I'm looking into a completely different design in the meantime, whereby level 1 would always represent the logged in entity (no matter what level they actually are in the hierarchy) but this is a lot of work and redesign.
