Reporting - Configure a filter so it is locked or hidden from viewers

In this article, we’ll show how to configure a filter so that it is locked, or hidden in a Power BI report. This can be a really useful step, as it can ensure that viewers see only information relevant to them, and that information is consistently presented clearly. When creating a report, you have the option to:

• Lock a filter so that a report user cannot change what you have put in place
• Hide a filter once you’ve applied it so that no one sees it
• Choose which filters remain editable by your report user

Note that report editing permissions are required to add and remove a locked/hidden filter.

Steps to lock and hide a filter in a Power BI report

1. Start a new User-created report or open an existing report
2. From the Filters panel, select a filter
3. To lock/unlock the filter, select the padlock. To hide/unhide the filter, select the 'eye' symbol:

Find out more about reporting and analytics with Microsoft Power BI

Join us live for Key techniques for using Power BI fixed reports in The Academy. We'll start with a tour of the Power BI reporting area, then, we’ll open up the Learning Progress report and using real-life examples, we’ll dive into the detail.

If you're using Reporting and Analytics already and have a question, come along to our 'Ask me Anything' events in the Academy to ask questions and share feedback directly with the team.

Join us for our update and roadmap live event to see the latest feature releases and roadmap for the next quarter and share feedback directly with the team. 

Don't have your Academy account yet? Contact your Customer Experience Manager or the Support Team to sign up today.