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...
For your reference.
Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft Learn
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.