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
- Start a new User-created report or open an existing report
- From the Filters panel, select a filter
- To lock/unlock the filter, select the padlock. To hide/unhide the filter, select the 'eye' symbol:
Get deeper learning in The Academy
If you’re completely new to reporting and analytics, then Get started: Reporting and analytics with Power BI is the place to start. We'll start by introducing Power BI’s top five features, then, we’ll take a deep dive into each feature, with links to related learning and tips from the Kallidus team along the way.
If you're starting to explore user-created reports, take a look at Power BI Reporting: Deep dive previews. In this short course, you'll get a quick preview of each 'deep dive' scenario. If a scenario sparks your interest, follow the links in the Lesson description to view the full course.
Do you have a question about reporting? Come to our 'Ask me Anything' events in the Academy to ask questions 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.
Comments
0 comments
Please sign in to leave a comment.