Forum Discussion

shamoonrahat's avatar
shamoonrahat
New Member
2 years ago
Solved

Implementing User-Specific Dynamic Matrix Tables in Power BI

Hi members, I’m seeking guidance on creating a dynamic matrix table within Power BI Service that tailors visibility and calculations to the specific user viewing the report. The goal is to filter ro...
  • shamoonrahat's avatar
    shamoonrahat
    2 years ago

    Hi Neeko,

     

    Thought through the scenario in detail and found out some key inputs. When preparing the matrix and underlying measures; would need to include User Principal Name and some conditions which would include <IS FILTER>, SWITCH Functions...

     

    So in this scenario, while RLS works - if any user logs in the dynamic table works in a way that the information filters automatically to show the required information through switch measure. 

shamoonrahat's avatar
shamoonrahat
New Member
2 years ago

Hi Neeko,

 

Thought through the scenario in detail and found out some key inputs. When preparing the matrix and underlying measures; would need to include User Principal Name and some conditions which would include <IS FILTER>, SWITCH Functions...

 

So in this scenario, while RLS works - if any user logs in the dynamic table works in a way that the information filters automatically to show the required information through switch measure.