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. 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi shamoonrahat ,

 

I think lbendlin  suggestion is a good idea and I'd like to add some steps for your reference:

 

(1) This is my test data. 

(2) New a role.

(3) View as roles.

For more details, please refer: Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft Learn

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.