Hide filters in Filters Pane

[vktravel]

Hello, 

Is it possible to hide certain filters in the Filters pane for certain users and keep them for the others? Can it be done with object-level security?

Thank you.

[Shravan133 · Accepted solution]

In Power BI, managing who can see or interact with certain filters in the Filters pane for specific users can be complex. Object-level security (OLS) is typically used to secure tables or columns within a dataset, not specific filters within the Filters pane. However, there are some strategies you can employ to achieve a similar effect:

Role-Level Security (RLS)

Role-Level Security (RLS) in Power BI can be used to restrict data access for specific users, but it won't hide the filters in the Filters pane itself. Instead, it filters the data based on the roles you define. Here's a high-level overview of how you might use RLS to control data visibility:

1. Define Roles in Power BI Desktop:

   • Go to the "Modeling" tab and select "Manage Roles".
   • Create roles and define DAX filter expressions to restrict data for each role.

2. Assign Users to Roles:

   • Publish the report to the Power BI service.
   • In the Power BI service, go to the dataset settings and assign users to the roles you defined.

Using Visual Level Filters and Bookmarks

While you can't directly hide filters in the Filters pane, you can create different views of your report for different users using bookmarks and visual-level filters:

1. Create Visual Level Filters:

   • Apply visual-level filters to your visuals to control what data is shown in different visuals for different user groups.

2. Create Bookmarks:

   • Create bookmarks for different user views. Each bookmark can have different filters applied.
   • Go to the "View" tab and open the "Bookmarks" pane.
   • Create and name bookmarks for each user group.

3. Create Buttons for Navigation:

   • Add buttons to your report for users to navigate between different bookmarks.
   • Configure the buttons to link to the appropriate bookmarks.

Example of Setting Up RLS

Let's assume you have a Sales table and you want to restrict access based on the Region column.

1. Define Roles:

   [Region] = "North"

2. Assign Roles to Users:

   • After publishing your report to the Power BI service, go to the dataset settings.
   • Under "Security", assign users to the "North" role.

Hide Filters Using RLS and Bookmarks

If you want to show different filters in the Filters pane for different users, you can use a combination of RLS and bookmarks to create separate report views:

1. Set Up Different Views Using Bookmarks:

   • Create different views of your report with the filters you want to display for each user group.
   • Save these views as bookmarks.

2. Use RLS to Control Data Access:

   • Define roles and assign users to roles as described above.

3. Navigation Buttons:

   • Add buttons that link to the different bookmarks so users can switch views.

Limitations

While these methods allow you to control data access and create different views, they don't directly hide or show specific filters in the Filters pane for different users. The Filters pane will still be visible, but the actual data shown will be controlled by RLS and bookmarks.

Advanced Options

For more advanced scenarios, consider using Power BI Embedded or the Power BI API to create custom filtering experiences. This allows you to build a more customized user experience where you have full control over what filters are available to different users.

By combining these techniques, you can create a more tailored experience for your users, ensuring that they see only the data and filters relevant to them