Matrix visual - change root node depending on context

[jrnhbc]

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...]

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...]

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.

[mickey64]

For your reference.

Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft Learn

[jrnhbc]

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.