Urgent help---Roles in powerbi

[Anonymous]

Hi Everyone,

    I need your help on role based filters in power bi.

I want to show the dashboards by using role based filter wise. From the above screenshot I give an example for our understanding.

I use four slicer to show the dashboards,

1.First I select state bank from multiple banks in a drop down 

2.If I click the place it displays the multiple place in a dropdown belongs to that selected bank only

3. If I click the designation it displays the multiple designation in a dropdown  belongs to that place only

4. If I click the username it displays the multiple username in a dropdown belongs to that selected designation only.

How can I do this in powerbi.. kindly help me on this role based work?

Advance thanks to all,

[amitchandak]

@Anonymous , not very clear to me

see RLS - Row Level security can help
https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-Unleash-row-level-security-patterns-in-Power/td-p/712613
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
https://www.blue-granite.com/blog/using-dynamic-row-level-security-with-organizational-hierarchies
https://docs.microsoft.com/en-us/power-bi/service-admin-rls
https://blog.tallan.com/2018/04/10/row-level-security-in-power-bi-part-1-roles-and-users/

[Anonymous]

Hi @amitchandak ,

  Thanks for your  reply. I tried what u shared the links I didnt get an idea about my expected results. I attach my screenshot for your reference.

From the above screenshot You are able to see the filters and the table,

In that filter only I want to use the roles

1. If I click customername like citi bank 

2. The places filter displays the related place to citi bank

3.The designation filter displays the related designation based on places

4.The username filter displays the details related to designation

After all the filters clicked then only the table data will show.. Is it possible? 

Queries:

 If the customername is more than 20 how can I give the roles dynamically?

 Advance thanks,