How to implement the page level filter in a report.

[SaikumarV]

how to hide a filter page from a report where developer can see 3 pages but manager can see all pages from the report.How to implement this power bi

[v-prasare]

We would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.

@Ilgar_Zarbali, @lbendlin  Thanks for your prompt response

Thanks,

Prashanth Are

MS Fabric community support

[Ilgar_Zarbali]

To show/hide pages based on user roles like Developer vs. Manager, use page navigation with RLS logic, because Power BI does not natively support page-level security.

Steps to Implement:

1. Create a Role Column in a Table:

• Example: UserAccess table with columns: Username, Role
• Add rows like:

   ilgar@sample.com, Developer
   qafur@sample.com, Manager

2. Create an RLS Role:

• Go to Modeling → Manage Roles
• Use DAX:

[Username] = USERNAME()​

Read my Article: https://www.linkedin.com/pulse/row-level-security-azepowerbicommunity-gqs4e/?trackingId=fdsyEb0CQhib...

3. Create a Navigation Table:

• List your page names: "Main", "Manager Page", etc.

4. Create a Navigation Button on Main Page:

• Use conditional formatting to show/hide buttons or use a slicer-driven navigation logic:
  
  

ShowManagerPage = IF(SELECTEDVALUE(UserAccess[Role]) = "Manager", 1, 0)
​

5. Hide Sensitive Page:

• Remove direct access via tabs.
• Add buttons only visible to Manager role to navigate to the restricted page.
• Use Bookmarks + Selection Pane to manage visibility.

This way, Managers can access all pages, but Developers won’t see buttons leading to restricted content — even though pages technically still exist in the report.

[lbendlin]

Page level security DOES NOT EXIST. Try not to waste your time.  Use separate reports.