Skip to main content

Power BI

Completed

More control over report Filters Pane - Hide certain filters from users

Vote (49) Share
Mathias Thierbach's profile image

Mathias Thierbach on 03 Feb 2017 22:19:55

When designing reports, I frequently find myself dealing with two types of filters:

1. Internal or "technical" filters that are required to make the report work correctly (for instance, a Current Week filter if it's a "Current Week" report)
2. Fields added to the filter pane explicitly for users to be able to interact with them.

The latter is quite important as interactive filtering by highlighting only works for one visual at a time.

Now, the fact that both types of filters necessarily show up in the filter pane, and are exposed to users, is really limiting.

At best, users get confused because there are too many fields available there, and some might not even make sense to them.
At worst, they might change a filter that is not supposed to be for public consumption and break the report.

Please give report authors the ability to hide specific filters from users.

Related - From a user's point of view, it would be much better if the order of filter groups was reversed (Report - Page - Visual). That way, when navigating between pages, the report-level filters would always show up in the same place, i.e. at the top. The current experience is quite confusing.

Administrator on 21 Nov 2018 06:02:40

Ability to hide filters are now part of November release as preview!

Comments (4)
Mathias Thierbach's profile image Profile Picture

Didier Terrien on 05 Jul 2020 23:48:15

RE: More control over report Filters Pane - Hide certain filters from users

There is a confusion now with the filter pane as it is used by developpers and end users. I consider the user experience is still not the best with the filter pane. I would like to have a more flexible solution with the possibility to add the slicers I want. So I developped my own solution.

Please have a look at this one minute video and share your comments there :

https://thebipower.fr/index.php/2019/02/01/add-a-filter-page-to-your-report/

Mathias Thierbach's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:24:20

RE: More control over report Filters Pane - Hide certain filters from users

Please also add the ability to rename these filters!

Mathias Thierbach's profile image Profile Picture

Power BI User on 05 Jul 2020 23:13:08

RE: More control over report Filters Pane - Hide certain filters from users

We need this feature to be applied ASAP, please.

Mathias Thierbach's profile image Profile Picture

Omer on 05 Jul 2020 23:02:23

RE: More control over report Filters Pane - Hide certain filters from users

Hi All,

I think, this idea was very well explained than other related ideas. However, the number of votes is key to notify the relevant team at Microsoft. I suggest that, while keeping this idea active, please add your vote and comment ALSO in the following related idea page which has gained more votes so far.
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/10319553-hide-filters-for-shared-reports-or-prevent-user-fr?page=1&per_page=20

I think this way we may get this idea implemented faster.

Thank you.