Forum Discussion
Role Level Security
Data Backgroud: The heriachy of data is Divison > Profit Centers, example there are 5 division and under each divions there are many Profit centers (Profit centers are unique to each divison). Each user is under a division and then under that divison there are many profit centers.
Achived: I was able to achive the dynamic role level security for Divison Level or Role Level.
Problem/Ask: I want to give the fexlibity to the users to switch between divion and their profit center. I know that can be achived using sliccers or filter but want to do that dynamically.
Please share your idea to tackle this situation.
1 Reply
Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.
