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:
Ask the Community🤝
Want to connect with peers and hear how they are using the Fixed reports? Our customer Community is a great place to get quick, relatable advice - so jump in, ask your question, and learn from the wider customer Community.
Get deeper learning in The Academy🎓
The Acadhttps://academy.kallidus-suite.com/emy provides structured learning paths you can follow at your own pace, along with live events where you can connect with the Kallidus team and fellow learners. Here's some relevant content to get you started:
Explore our Deep dive courses in The Academy, and watch as Gary builds reports from scratch to meet specific briefs.
If you prefer to start at the beginning, check out Get Started: Reporting and Analytics with Power BI.
Need quick answers? Check out our FAQ, Reporting and Analytics with Power BI, or join our regular Ask Me Anything: Reporting live events, to ask your question directly to a Power BI expert. Search PWRFAQ in The Academy for real-world use cases, examples, and scenarios with User-created reports.
Don't have your Academy account yet? Contact your Customer Experience Manager or the Support Team to sign up today.