topic Re: Filtering dashboards in Developer

Filtering dashboards

trushna — Thu, 20 May 2021 06:11:07 GMT

I have a requirement to create different dashboards for different User roles, and which will be displayed to that user role only

Eg. : If Manager will log in into CRM then associated dashboard will be shown to him and if Sales person will log in then his dashboard will be shown.

Please help me how can I achieve this?

@Patrik

Re: Filtering dashboards

Anonymous — Mon, 24 May 2021 01:53:57 GMT

HI @trushna,

You can take a look at the following link to use the USERNAME function to achieve dynamic RLS roles:

Solved: RLS with UserName() - Microsoft Power BI Community

For the manager/user level filter, you can create a 'user_manger' mapping table with 'user id' and 'manger id'.
Then you can modify the RLS filter expression to lookup correspond 'user id' from the user table and filter 'user_manger' table 'manger id' and 'user id' fields with 'OR' logic and apply filter effects to other tables based on relationships.

Regards,

Xiaoxin Sheng

Re: Filtering dashboards

trushna — Mon, 24 May 2021 05:29:09 GMT

Thanks @Anonymous,

But in my case I dont want to use "Manage role" feature of power bi.

Is there any alternative to do this?

Re: Filtering dashboards

Anonymous — Tue, 25 May 2021 09:19:39 GMT

Hi @trushna,

Did you mind adding an additional field to the user table?

If that is the case, I'd like to suggest you add the is_Manage field for the advanced filter effect. Then you can modify the filter expressions to check the user id and is_Manage field.
If the current user is a manager, then you can filter on the other field(e.g. department, group) instead of the 'user id' field to show all records he has permission to view.

Logic:

1. Use 'username' function to get 'user id' and correspond 'is manage' field values.
2. If the current user is a manager, filter on the parent field(group/department) that he manages; If he isn't a manager, filter on the 'user id' field.
Regards,

Xiaoxin Sheng